Re: Fast index build vs. PITR

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Fast index build vs. PITR
Дата
Msg-id 200406010221.i512LNr29297@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Fast index build vs. PITR  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Fast index build vs. PITR  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I assume if someone turns on archiving in postgresql.conf, sighups the
> > postmaster, then does a tar backup, they should be able to do archiving,
> > no?
> 
> I would have zero problem with labeling the archive parameter as
> changeable only at postmaster start.

I guess the question is whether it would be possible to start/stop it at
other times.  And what process are we going to use to do a tar backup? 
Do they turn off archiving before doing the tar, or tell the system to
tar to another location?  

And you brought up the issue of how do we feed multilple archive files
back into the xlog directory during restore if they don't all fit on the
disk.

I think we need to explore the procedures we are going to use for PITR.

Also, do we need to do tar in a special way, like tar up a specific file
first?


--  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,
Pennsylvania19073
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fast index build vs. PITR
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fast index build vs. PITR