Message-ID: <51F90E3B.6030604@uni-graz.at>
Date: Wed, 31 Jul 2013 15:16:43 +0200
From: =?ISO-8859-1?Q?J=FCrgen_Fuchsberger?= <juergen.fuchsberger@uni-graz.at>
Organization: Wegener Center for Climate and Global Change
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:17.0) Gecko/20130704 Icedove/17.0.7
MIME-Version: 1.0
To: <pgsql-admin@postgresql.org>
Subject: Problem: pg_ctl does not not stop postgres properly even with
 immediate option
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="EKpi3V1j1mhpb6Wh3MkirUH0SNINP1RJL"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--EKpi3V1j1mhpb6Wh3MkirUH0SNINP1RJL
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 runnin=
g:

> 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


--EKpi3V1j1mhpb6Wh3MkirUH0SNINP1RJL
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iF4EAREIAAYFAlH5DjsACgkQ4RNsce5/DgBXbgD/TWuDnHoUkPFpvRtutdGown13
qiuGO4TK0YuRHnQCew4A/ih1VHNB0gJOQvFA5FquK9ogiy0EbsBoORROA4DNG8V4
=Cb7k
-----END PGP SIGNATURE-----

--EKpi3V1j1mhpb6Wh3MkirUH0SNINP1RJL--