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

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

From
Glyn Astill
Date:
 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.





      __________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com



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

From
Erik Jones
Date:
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