On Wed, 2008-12-10 at 18:34 -0500, Rutherdale, Will wrote: > Thanks very much, Steve. > > The main (but not only) type of data replication activity I'm interested > in right now would be the warm standby. Thus it appears from the > documents you showed me that log shipping is one solution currently > available in PostgreSQL. I would want to make this work between > geographically separated machines that have TCP/IP connectivity between > them. > > From what I understand from the documents so far, I can set up log > shipping using pgsql without any external packages. There also seems to > be support for periodic backups from the primary to the warm standby.
You can. There is a BSD open source project here: http://projects.commandprompt.com/public/pitrtools That will help you with your warm standby needs quite a bit. Joshua D. Drake -- PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
