Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux