[gentoo-user] postgresql-9.1 start - ERROR

[gentoo-user] postgresql-9.1 start - ERROR

[Joseph]

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?

-- 
Joseph

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

[Joseph]

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

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

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

[Joseph]

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