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. Yes, everything you need for log shipping has been contributed to the main project. If you read things elsewhere, please refer closely to the docs which are the most accurate source of detail. There is some further info here, but you won't need all of the tools listed there in typical cases. http://www.2ndquadrant.com/replication.htm If you think anything else is required, please let us know and we can update the docs, tools etc.. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
