Re: Fwd: [ADMIN] Shutting down warm standby server? "

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(at)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(at)myemma(dot)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