On 06/10/14 14:54, J. Roeleveld wrote:
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
Thank you for the information. I removed the link /usr/share/zoneinfo/posix
and it worked. I don't know what this posix link for?
On my system I only have stable postgresql 9.1 and 9.3 I don't have 9.2
[D] dev-db/postgresql-server
Available versions:
(8.3) 8.3.18 8.3.19 ~8.3.19-r1 8.3.20
(8.4) 8.4.11 8.4.12 ~8.4.12-r1 8.4.13
(9.0) 9.0.7 9.0.8 ~9.0.8-r1 9.0.9
(9.1) 9.1.3 9.1.4 ~9.1.4-r1 9.1.5
(9.2) ~9.2.0_beta1-r1 ~9.2.0_beta2 ~9.2.0_beta2-r1 ~9.2.0_beta3 ~9.2.0_rc1
(9.3) **9999
--
Joseph
