| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "Josh Harrison" <joshques(at)gmail(dot)com> |
| Cc: | "Postgresql General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Replication using WAL files |
| Date: | 2007-12-07 15:01:07 |
| Message-ID: | b42b73150712070701q41b0485axb7dc734ebc54258a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Dec 7, 2007 9:52 AM, Josh Harrison <joshques(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Staubo | 2007-12-07 15:08:13 | Re: Replication using WAL files |
| Previous Message | Josh Harrison | 2007-12-07 14:52:47 | Replication using WAL files |