Re: [gentoo-user] postgresql-9.1 start - ERROR

[J. Roeleveld]

On Monday, June 09, 2014 10:12:25 PM Joseph wrote:
> On 06/09/14 22:08, Joseph wrote:
> >After upgrade when I try to start postgresql I get error:
> >
> >/etc/init.d/postgresql-9.1 start
> >
> > * Starting PostgreSQL ...
> > * start-stop-daemon: did not create a valid pid in
> > `/var/lib/postgresql/9.1/data/postmaster.pid' * Check the log for a
> > possible explanation of the above error.
> > *     /var/lib/postgresql/9.1/data/postmaster.log
> >
> >            [>
> >!! ]
> >
> > * ERROR: postgresql-9.1 failed to start
> >
> >What is is looking for?
>
> more information from:
> /var/lib/postgresql/9.1/data/postmaster.log
>
> LOG:  database system was shut down at 2014-06-08 09:05:33 MDT
> LOG:  database system is ready to accept connections
> LOG:  autovacuum launcher started
> WARNING:  pgstat wait timeout
> WARNING:  pgstat wait timeout
> LOG:  received smart shutdown request
> LOG:  autovacuum launcher shutting down
> LOG:  shutting down
> LOG:  database system is shut down
> FATAL:  exceeded maxAllocatedDescs (16) while trying to open directory
> "/usr/share/zoneinfo" FATAL:  exceeded maxAllocatedDescs (16) while trying
> to open directory "/usr/share/zoneinfo" FATAL:  exceeded maxAllocatedDescs
> (16) while trying to open directory "/usr/share/zoneinfo" FATAL:  exceeded
> maxAllocatedDescs (16) while trying to open directory "/usr/share/zoneinfo"


Joseph,

Known issue.
It is unclear if the issue is with PostgeSQL or timezone data or how Gentoo 
packages it.

See bug:
https://bugs.gentoo.org/show_bug.cgi?id=486556

I see 3 possible solutions:
1) Upgrade to PostgreSQL 9.2
2) Downgrade timezone-data to: sys-libs/timezone-data-2013c
3) manually delete the problematic symlink: /usr/share/zoneinfo/posix

I have NOT tested any of these options myself. It is up to you to test this on 
your system.
I think options 1 or 2 have the least amount of risk.

--
Joost