Re: Replication using WAL files - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Replication using WAL files
Date
Msg-id b42b73150712070701q41b0485axb7dc734ebc54258a@mail.gmail.com
Whole thread Raw
In response to Replication using WAL files  ("Josh Harrison" <joshques@gmail.com>)
List pgsql-general
On Dec 7, 2007 9:52 AM, Josh Harrison <joshques@gmail.com> wrote:
> I tried the 'Continuous Archiving and PITR' in my test database and it works
> fine. But this set-up is only for a warm standby server...right?! Is it
> possible to make both the servers work asynchronously, while the primary
> server takes up all write queries and the read queries can be sent to both
> primary and 2nd server .And can the 2nd server  be updated using the WAL
> files (WAL shipping) of the primary server asynchronously (while both the
> servers are up)?

PITR currently is for HA only, not replication.  Check out slony.

merlin

pgsql-general by date:

Previous
From: "Josh Harrison"
Date:
Subject: Replication using WAL files
Next
From: "Alexander Staubo"
Date:
Subject: Re: Replication using WAL files