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@myemma.com
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
