From: "J. Roeleveld" <joost@antarean.org>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] postgresql-9.1 start - ERROR
Date: Tue, 10 Jun 2014 14:54:34 +0200 [thread overview]
Message-ID: <2264001.YiXMKbSCoo@andromeda> (raw)
In-Reply-To: <20140610041225.GF24946@syscon7>
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
next prev parent reply other threads:[~2014-06-10 12:55 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-06-10 4:08 [gentoo-user] postgresql-9.1 start - ERROR Joseph
2014-06-10 4:12 ` Joseph
2014-06-10 12:54 ` J. Roeleveld [this message]
2014-06-10 13:38 ` Joseph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=2264001.YiXMKbSCoo@andromeda \
--to=joost@antarean.org \
--cc=gentoo-user@lists.gentoo.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox