On Jan 2, 2008, at 7:47 AM, Glyn Astill wrote:
Hi people, I've setup a warm standby reading WAL files, however when I try to shut it down I get the message "server does not shut down". Can someone help please, I presume it has something to do with the server being busy waiting for the next WAL file? What is the correct way to shut down a server reading WALs? The command line output is below: postgres@way5c:/mnt/archive$ /usr/local/pgsql/bin/pg_ctl stop -D /data/postgres/ -m smart waiting for server to shut down............................................................... failed pg_ctl: server does not shut down If I do a ps -ax: 7956 pts/0 S 0:00 /usr/local/pgsql/bin/postgres -D /data/postgres/ 7957 ? Ss 0:10 postgres: startup process 7371 ? S 0:00 /bin/bash /data/postgres/restore.sh /mnt/archive/000000010000001A000000A8 pg_xlog/RECOVERYXLOG 1160 ? S 0:00 sleep 1 1161 pts/0 R+ 0:00 ps -ax it looks like it's waiting for the next WAL file.
I've seen the same behavior with the '-m smart' option while in standby recovery. The '-m fast' option seems to work fine, though.
Erik Jones Software Developer | Emma® erik@xxxxxxxxxx 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
