Mike Biamonte wrote:
>
>
> Caveat: I'm not a pg hacker, I apologize
> in advance if this is a dumb question, but
> it has been nagging at me, and I don't
> know who else to ask.
>
> If the WAL is a record of all transactions,
> and if the checkpoint process can be managed
> tightly, is it possible to copy the WAL
> files from a master DB and use them to keep
> a slave DB in sync? This seems like it
> would be an easy way to slave a backup system
> without additional load on the primary....
WAL files are kept only until an fsync(), checkpoint, then reused.
Also, the info is tied to direct locations in the file. You could do
this for hot backup, but it would require quite bit of coding to make it
work.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026