Re: BUG #14320: systemd terminates postgresql hot standby instance 90 seconds after start

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(at)9(dot)4-at_run(dot)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(dot)papst(at)univie(dot)ac(dot)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(dot)papst(at)univie(dot)ac(dot)at
Universitaetsstrasse 7 | Phone: +43 1 4277 / 140 36
A-1010 Vienna, Austria, Europe | Fax.: +43 1 4277 / 8 140 36