Re: WAL recovery

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: WAL recovery
Дата
Msg-id 1140704662.8759.121.camel@localhost.localdomain
обсуждение исходный текст
Ответ на WAL recovery  (Andy Shellam <andy.shellam@mailnetwork.co.uk>)
Ответы Re: WAL recovery  (Andy Shellam <andy@andycc.net>)
Список pgsql-admin
On Wed, 2006-02-22 at 16:26 +0000, Andy Shellam wrote:

> Is this scenario possible - that you can keep rolling forward over log
> files as long as necessary, or do you always have to start from a base
> backup?  Nothing is changing on the spare, it's literally a sitting
> duck.

You'll need a restore_command that is a script that sits in a wait loop
when the file it is asked for is not available yet, or other conditions
have occurred such as notification of switchover (manually or
otherwise). When those conditions occur the script should return a
non-zero error condition.

There should be no recovery_target* settings.

Best Regards, Simon Riggs



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

Предыдущее
От: Arnau
Дата:
Сообщение: Re: Delete performance
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: large object unlinking