From: | Jürgen Fuchsberger <juergen(dot)fuchsberger(at)uni-graz(dot)at> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Problem: pg_ctl does not not stop postgres properly even with immediate option |
Date: | 2013-07-31 13:16:43 |
Message-ID: | 51F90E3B.6030604@uni-graz.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | German Becker | 2013-07-31 16:25:41 | Re: Disk latency goes up during certaing pediods |
Previous Message | Asmus Reinhard | 2013-07-31 07:14:51 | Restore after pg_dumpall |