Re: BUG #14320: systemd terminates postgresql hot standby instance 90 seconds after start - Mailing list pgsql-bugs

From Andreas Papst
Subject Re: BUG #14320: systemd terminates postgresql hot standby instance 90 seconds after start
Date
Msg-id 57D8F84E.702@univie.ac.at
Whole thread Raw
In response to Re: BUG #14320: systemd terminates postgresql hot standby instance 90 seconds after start  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: BUG #14320: systemd terminates postgresql hot standby instance 90 seconds after start  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-bugs
Hey Peter,

thank you for your offer.

# cat /etc/debian_version
8.5
# dpkg -l | grep postgres
-------------------------------------------------------------------
ii  pgdg-keyring                      2014.1                         all
         keyring for apt.postgresql.org
ii  postgresql-9.4                    9.4.9-1.pgdg80+1
amd64        object-relational SQL database, version 9.4 server
ii  postgresql-9.5                    9.5.4-1.pgdg80+1
amd64        object-relational SQL database, version 9.5 server
ii  postgresql-client-9.4             9.4.9-1.pgdg80+1
amd64        front-end programs for PostgreSQL 9.4
ii  postgresql-client-9.5             9.5.4-1.pgdg80+1
amd64        front-end programs for PostgreSQL 9.5
ii  postgresql-client-common          175.pgdg80+1                   all
         manager for multiple PostgreSQL client versions
ii  postgresql-common                 175.pgdg80+1                   all
         PostgreSQL database-cluster manager
ii  postgresql-contrib-9.4            9.4.9-1.pgdg80+1
amd64        additional facilities for PostgreSQL
ii  postgresql-contrib-9.5            9.5.4-1.pgdg80+1
amd64        additional facilities for PostgreSQL
-------------------------------------------------------------------

attached files:

systemctl cat postgresql.service
systemctl cat postgresql@9.4-at_run.service
/etc/postgresql/9.4/at_run/postgresql.conf
/etc/postgresql/9.4/at_run/start.conf
/usr/bin/pg_ctlcluster

Best regards
Andreas

On 09/13/2016 05:52 PM, Peter Eisentraut wrote:
> On 9/9/16 6:50 AM, andreas.papst@univie.ac.at wrote:
>> when starting a hot standby database insstance with
>> `systemctl start postgresql',
>> anything works perfect: WAL files are beeing applied, r/o connections are
>> able to query the database, but after 90 seconds (systemd
>> DefaultTimeoutStartSec) postgresql is beeing shut down:
>
> This is all quite plausible, but it depends on how your systemd service
> for postgresql is configured.  So please post that if you want us to
> analyze it.
>

--
________________________________________________________________________
Andreas Papst                      |
Vienna University Computer Center  |  E-Mail: andreas.papst@univie.ac.at
Universitaetsstrasse 7             |  Phone: +43 1 4277 / 140 36
A-1010 Vienna, Austria, Europe     |  Fax.: +43 1 4277 / 8 140 36

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14322: Possible inconsistent behavior with timestamp_to_str()
Next
From: maxim.boguk@gmail.com
Date:
Subject: BUG #14324: Deadlock? between queries and startup process on standby replica.