BUG #10736: Database does somtimes not startup again after restart - Mailing list pgsql-bugs

From marcel.hanke@1und1.de
Subject BUG #10736: Database does somtimes not startup again after restart
Date
Msg-id 20140623083331.2622.38092@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #10736: Database does somtimes not startup again after restart  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      10736
Logged by:          Marcel Hanke
Email address:      marcel.hanke@1und1.de
PostgreSQL version: 9.1.13
Operating system:   Debian
Description:

After an update of any related Packet (or the postgres it self), witch
requires an restart of the Database, the db sometimes doesn't start up
again.
The Postgres is used to provide data to an Powerdns Server and runs in an
Master-Slave replication.

Errormassages:
postgres_main[3195]: [1-1] 2014-06-20 12:59:07 CEST FATAL:  the database
system is starting up
postgres_main[3196]: [1-1] 2014-06-20 12:59:07 CEST FATAL:  the database
system is starting up
pdns[3061]: gpgsql Connection failed: Unable to connect to database, connect
string: dbname=pdns user=postgres host=127.0.0.1 port=5432
password=<HIDDEN>: FATAL:  the database system is starting up
pdns[3061]: Caught an exception instantiating a backend: Unable to launch
gpgsql connection: Unable to connect to database, connect string:
dbname=pdns user=postgres host=127.0.0.1 port=5432 password=<HIDDEN>: FATAL:
 the database system is starting up
pdns[3061]: Cleaning up

The Error doesn't accrue every time. It's atm not possible to reproduce the
error on an test system, so I can't provide an debug log.

The configuration of the relevant postgres is mostly standard.
Replitation Config:
unix_socket_directory = '/var/run/postgresql'
hot_standby = on

Greetings Marcel

pgsql-bugs by date:

Previous
From: wildfox81@hotmail.com
Date:
Subject: BUG #10726: database gets to an older backup out of nowhere!!!
Next
From: digoal@126.com
Date:
Subject: BUG #10734: PostgreSQL 9.3.4 shutdown forever in zfsonlinux 0.6.3-1 filesystem