Problem: pg_ctl does not not stop postgres properly even with immediate option

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


Attachment: signature.asc
Description: OpenPGP digital signature


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux