Search Postgresql Archives

Re: Data Replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux