Re: [HACKERS] Point in Time Recovery

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Point in Time Recovery
Дата
Msg-id 200407171908.i6HJ8hc06808@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Point in Time Recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Point in Time Recovery
Список pgsql-patches
Tom Lane wrote:
> [ ... some desultory reading of PITR patch ... ]
>
> What is the point of having both archive_program and archive_dest as
> GUC variables?  Wouldn't it be simpler to fold them into one parameter,
> viz
>
>     archive_command = 'cp %s /archivedir'
>
> For that matter, do we need a separate archive_mode boolean?  The one
> thing I can positively guarantee about archive_dest (or archive_command)
> is that we cannot come up with a useful default for it (no, /tmp isn't
> good).  Therefore it does not seem very reasonable to let the user turn
> on archiving without having explicitly specified an archive destination.

I assume archive_dest is used for both archive and recovery of archives.

> I propose that we fold all three GUC flags into a single archive_command
> string whose built-in default is an empty string, and you enable
> archiving by setting it to something nonempty.

I think the idea is that you would turn archiving on and off regularly
while you might never change the archive_command value.  Also, how would
you disable it?  Set it to "", and if you do, you then have not way to
remember your command string when you want to re-enable it.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Point in Time Recovery
Следующее
От: "Jonathan M. Gardner"
Дата:
Сообщение: Subtransaction documentation