Re: WAL -> Replication

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mike Biamonte <mbiamonte(at)affinitysolutions(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WAL -> Replication
Date: 2002-04-25 14:37:34
Message-ID: 200204251437.g3PEbYb11872@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-04-25 14:41:56 Re: non-standard escapes in string literals
Previous Message Andreas Scherbaum 2002-04-25 14:34:26 Re: new food for the contrib/ directory