Обсуждение: Shutting down warm standby server? "
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 waikting for the next WAL file. __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
Glyn Astill <glynastill@yahoo.co.uk> writes: > 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". > 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 Well, yeah, because you told it "-m smart" which is defined as "don't exit until all work is done". "-m fast" should work though, at least in 8.2.x --- if you are using something older, try "-m immediate". regards, tom lane
Aha.. excellent, thanks Tom! Sorry, I shall try to RTFM in the future. --- Tom Lane <tgl@sss.pgh.pa.us> wrote: > Glyn Astill <glynastill@yahoo.co.uk> writes: > > 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". > > > 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 > > Well, yeah, because you told it "-m smart" which is defined as > "don't > exit until all work is done". "-m fast" should work though, at > least > in 8.2.x --- if you are using something older, try "-m immediate". > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire > to > choose an index scan if your joining column's datatypes do > not > match > __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com