Re: Replication through WAL

Bruce Momjian wrote:
Okay, would it be helpful if I made a few suggestions on things that I
as a user/tool developer of postgres might find helpful?

>
> > Is there an easy way to read the WAL files generated by Postgres? I'm
> > looking into writting a replication deamon for postgres and think that
> > the WAL files are the best way to know what has happened to the db and
> > what has to be replicated. I have a roughed out idea of how to code it
> > up but the only thing I'm really wrestling with is how read the WAL
> > files. Can anyone give me some pointers. I've looked at all the xlog*
> > code and have a basic understading of how it works, but not a real good
> > one. Any help on this would be appreciated. Thanks
>
> Many believe WAL will be the basis for further replication features.
> We will discuss this as part of 7.2 development in a few weeks.
>
> --
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html