Re: Data Replication

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