From: Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
To: pgsql-admin@postgresql.org
Subject: Problem: pg_ctl does not not stop postgres properly even with immediate option
Date: Wed, 31 Jul 2013 15:16:43 +0200
Message-ID: <51F90E3B.6030604@uni-graz.at> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi all,
I am on a Debian wheezy system with postgresql 9.1 installed. I have a
hot standby configuration with the standby server doing the job of
taking backups of the database. For this purpose I stop the database,
start rsync, then start the DB again.
This afternoon I did some tests and found that postgres did not stop as
I expected using
> /etc/init.d/postgresql stop
so I tried
> pg_ctlcluster --force 9.1 main stop
Still without success, next:
> pg_ctlcluster 9.1 main stop -- -m immediate
Stopped the main postgres process but the writer process was still running:
> ps -ef | grep postgres
postgres 14228 14224 0 14:34 ? 00:00:03 postgres: writer process
wegnet 28059 22011 0 12:48 pts/0 00:00:00 tail -f
/var/log/postgresql/postgresql-9.1-main.log
Also pg_ctlcluster exit status was 0 which is not helpful in such a
situation.
One note: During all this the server was under heavy load recovering
lots of wal files.
Any ideas?
Best,
Juergen
Attachments:
signature.asc (application/pgp-signature, 290B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: juergen.fuchsberger@uni-graz.at
Subject: Re: Problem: pg_ctl does not not stop postgres properly even with immediate option
In-Reply-To: <51F90E3B.6030604@uni-graz.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox