Pg_standby and shutting down the warm standby

Поиск
Список
Период
Сортировка
От Woody Woodring
Тема Pg_standby and shutting down the warm standby
Дата
Msg-id 02f701c7b1cd$c735c3b0$80b1a8c0@istructure.com
обсуждение исходный текст
Ответы Re: Pg_standby and shutting down the warm standby
Список pgsql-general
I am wondering if there is a proper procedure for shutting down the
warm_standby server (8.2.4)?  I am using pg_standby as my restore script in
my testing:

[postgres@jbeam]$ cat recovery.conf
restore_command = 'pg_standby -m -d -s 5 -w 0 -t /tmp/pgsql.trigger.5432
/usr/local2/pg_archive %f %p 2>> standby.log'

My issue is it looks like the when the warm_standby comes back up, it is
looking for a file that has already been loaded (and deleted).  It was
looking for log '*30' when it was shut down, but upon startup again it is
looking for '*2F'.

Thanks,

Woody


Standby.log

Trigger file         : /tmp/pgsql.trigger.5432
Waiting for WAL file : /usr/local2/pg_archive/00000001000000000000002E
WAL file path        : 00000001000000000000002E
Restoring to...      : pg_xlog/RECOVERYXLOG
Sleep interval       : 5 seconds
Max wait interval    : 0 forever
Command for restore  : mv /usr/local2/pg_archive/00000001000000000000002E
pg_xlog/RECOVERYXLOG
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
.
.
.
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
running restore      : success

Trigger file         : /tmp/pgsql.trigger.5432
Waiting for WAL file : /usr/local2/pg_archive/00000001000000000000002F
WAL file path        : 00000001000000000000002F
Restoring to...      : pg_xlog/RECOVERYXLOG
Sleep interval       : 5 seconds
Max wait interval    : 0 forever
Command for restore  : mv /usr/local2/pg_archive/00000001000000000000002F
pg_xlog/RECOVERYXLOG
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
.
.
.
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
running restore      : success

Trigger file         : /tmp/pgsql.trigger.5432
Waiting for WAL file : /usr/local2/pg_archive/000000010000000000000030
WAL file path        : 000000010000000000000030
Restoring to...      : pg_xlog/RECOVERYXLOG
Sleep interval       : 5 seconds
Max wait interval    : 0 forever
Command for restore  : mv /usr/local2/pg_archive/000000010000000000000030
pg_xlog/RECOVERYXLOG
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
.
.
.
WAL file not present yet. Checking for trigger file...
Trigger file         : /tmp/pgsql.trigger.5432
Waiting for WAL file : /usr/local2/pg_archive/00000001.history
WAL file path        : 00000001.history
Restoring to...      : pg_xlog/RECOVERYHISTORY
Sleep interval       : 5 seconds
Max wait interval    : 0 forever
Command for restore  : mv /usr/local2/pg_archive/00000001.history
pg_xlog/RECOVERYHISTORY
running restore      : history file not found

Trigger file         : /tmp/pgsql.trigger.5432
Waiting for WAL file : /usr/local2/pg_archive/00000001000000000000002F
WAL file path        : 00000001000000000000002F
Restoring to...      : pg_xlog/RECOVERYXLOG
Sleep interval       : 5 seconds
Max wait interval    : 0 forever
Command for restore  : mv /usr/local2/pg_archive/00000001000000000000002F
pg_xlog/RECOVERYXLOG
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...
WAL file not present yet. Checking for trigger file...


----------------------------------------
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3550 x813
www.iglass.net


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle
Следующее
От: PFC
Дата:
Сообщение: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle