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