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

Поиск
Список
Период
Сортировка
От Glyn Astill
Тема Fwd: [ADMIN] Shutting down warm standby server? "
Дата
Msg-id 345216.50154.qm@web25811.mail.ukl.yahoo.com
обсуждение исходный текст
Ответы Re: Fwd: [ADMIN] Shutting down warm standby server? "  (Erik Jones <erik@myemma.com>)
Список pgsql-general
 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: visibility rules for AFTER UPDATE Constraint Triggers Function
Следующее
От: "William Temperley"
Дата:
Сообщение: Creating XML/KML documents from single tables