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@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