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