| 1 |
On 06/10/14 14:54, J. Roeleveld wrote: |
| 2 |
>On Monday, June 09, 2014 10:12:25 PM Joseph wrote: |
| 3 |
>> On 06/09/14 22:08, Joseph wrote: |
| 4 |
>> >After upgrade when I try to start postgresql I get error: |
| 5 |
>> > |
| 6 |
>> >/etc/init.d/postgresql-9.1 start |
| 7 |
>> > |
| 8 |
>> > * Starting PostgreSQL ... |
| 9 |
>> > * start-stop-daemon: did not create a valid pid in |
| 10 |
>> > `/var/lib/postgresql/9.1/data/postmaster.pid' * Check the log for a |
| 11 |
>> > possible explanation of the above error. |
| 12 |
>> > * /var/lib/postgresql/9.1/data/postmaster.log |
| 13 |
>> > |
| 14 |
>> > [> |
| 15 |
>> >!! ] |
| 16 |
>> > |
| 17 |
>> > * ERROR: postgresql-9.1 failed to start |
| 18 |
>> > |
| 19 |
>> >What is is looking for? |
| 20 |
>> |
| 21 |
>> more information from: |
| 22 |
>> /var/lib/postgresql/9.1/data/postmaster.log |
| 23 |
>> |
| 24 |
>> LOG: database system was shut down at 2014-06-08 09:05:33 MDT |
| 25 |
>> LOG: database system is ready to accept connections |
| 26 |
>> LOG: autovacuum launcher started |
| 27 |
>> WARNING: pgstat wait timeout |
| 28 |
>> WARNING: pgstat wait timeout |
| 29 |
>> LOG: received smart shutdown request |
| 30 |
>> LOG: autovacuum launcher shutting down |
| 31 |
>> LOG: shutting down |
| 32 |
>> LOG: database system is shut down |
| 33 |
>> FATAL: exceeded maxAllocatedDescs (16) while trying to open directory |
| 34 |
>> "/usr/share/zoneinfo" FATAL: exceeded maxAllocatedDescs (16) while trying |
| 35 |
>> to open directory "/usr/share/zoneinfo" FATAL: exceeded maxAllocatedDescs |
| 36 |
>> (16) while trying to open directory "/usr/share/zoneinfo" FATAL: exceeded |
| 37 |
>> maxAllocatedDescs (16) while trying to open directory "/usr/share/zoneinfo" |
| 38 |
> |
| 39 |
> |
| 40 |
>Joseph, |
| 41 |
> |
| 42 |
>Known issue. |
| 43 |
>It is unclear if the issue is with PostgeSQL or timezone data or how Gentoo |
| 44 |
>packages it. |
| 45 |
> |
| 46 |
>See bug: |
| 47 |
>https://bugs.gentoo.org/show_bug.cgi?id=486556 |
| 48 |
> |
| 49 |
>I see 3 possible solutions: |
| 50 |
>1) Upgrade to PostgreSQL 9.2 |
| 51 |
>2) Downgrade timezone-data to: sys-libs/timezone-data-2013c |
| 52 |
>3) manually delete the problematic symlink: /usr/share/zoneinfo/posix |
| 53 |
> |
| 54 |
>I have NOT tested any of these options myself. It is up to you to test this on |
| 55 |
>your system. |
| 56 |
>I think options 1 or 2 have the least amount of risk. |
| 57 |
> |
| 58 |
>-- |
| 59 |
>Joost |
| 60 |
|
| 61 |
Thank you for the information. I removed the link /usr/share/zoneinfo/posix |
| 62 |
and it worked. I don't know what this posix link for? |
| 63 |
|
| 64 |
On my system I only have stable postgresql 9.1 and 9.3 I don't have 9.2 |
| 65 |
|
| 66 |
[D] dev-db/postgresql-server |
| 67 |
Available versions: |
| 68 |
(8.3) 8.3.18 8.3.19 ~8.3.19-r1 8.3.20 |
| 69 |
(8.4) 8.4.11 8.4.12 ~8.4.12-r1 8.4.13 |
| 70 |
(9.0) 9.0.7 9.0.8 ~9.0.8-r1 9.0.9 |
| 71 |
(9.1) 9.1.3 9.1.4 ~9.1.4-r1 9.1.5 |
| 72 |
(9.2) ~9.2.0_beta1-r1 ~9.2.0_beta2 ~9.2.0_beta2-r1 ~9.2.0_beta3 ~9.2.0_rc1 |
| 73 |
(9.3) **9999 |
| 74 |
|
| 75 |
|
| 76 |
-- |
| 77 |
Joseph |
Archives