Forum OpenACS Q&A: Postgres Replication

Posted by Steve Manning on 08/18/04 12:29 AM

Hi Folks

I've been asked to look at the possibilities of using a master/slave replication tool for one of our sites.

I'm considering dbmirror which ships in the contribs folder of Postgres. Does anyone have any experience of running dbmirror or one of the other pg replication tools? Are there any better options around and are there any pitfalls of which I should be aware?

If I go down the dbmirror route would the community be interested in the config and documentation to add to the installable options for OACS?

- Steve

2: Re: Postgres Replication (response to 1)

Posted by Rocael Hernández Rizzardini on 08/18/04 02:35 AM

Hi Steve,
any contribution in this area is always important to oacs, so feel free to keep us posted about your results...

3: Re: Postgres Replication (response to 1)

Posted by George Essig on 08/18/04 08:10 PM

You should also consider slony at http://slony.info. It's relatively new, but seems to have a lot of momentum. Slony is written by Jan Wieck, a core developer of PostgreSQL.

George Essig

4: Re: Postgres Replication (response to 3)

Posted by Steve Manning on 08/19/04 01:06 AM

Thanks George, someone else has also suggested that to me and the docs look quite good.

I've added it to my list.

- Steve

5: Re: Postgres Replication (response to 1)

Posted by Andrew Piskorski on 08/20/04 06:23 AM

This older thread also has some other links relevent to PostgreSQL replication.