Re: Fast index build vs. PITR - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Fast index build vs. PITR
Date
Msg-id 200406010221.i512LNr29297@candle.pha.pa.us
Whole thread Raw
In response to Re: Fast index build vs. PITR  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fast index build vs. PITR
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fast index build vs. PITR
Next
From: Tom Lane
Date:
Subject: Re: Fast index build vs. PITR