From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Alexander Staubo <alex(at)purefiction(dot)net> |
Cc: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: replication in Postgres |
Date: | 2007-11-26 07:34:23 |
Message-ID: | 1196062463.4246.596.camel@ebony.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, 2007-11-25 at 23:38 +0100, Alexander Staubo wrote:
> On 11/25/07, Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> wrote:
> > So far the only methods I see would be usable for us are Slony I and
> > WAL log shipping.
>
> WAL shipping probably does not work the way you think it does. The
> secondary server that receives the log pieces is not actually able to
> serve any queries; it only processes them as part of a sort of
> indefinitely extended recovery procedure. Therefore, the current
> shipping support is only good for maintaining a "warm standby" server.
> The manual explains this in detail.
>
> Someone is working on extending the current system to allow read-only
> queries on a standby server [1], thus making it a "hot standby", but
> this feature apparently won't be included until 8.4 [2].
>
> [1] http://archives.postgresql.org/pgsql-hackers/2007-02/msg01390.php
> [2] http://archives.postgresql.org/pgsql-general/2007-09/msg00752.php
http://archives.postgresql.org/pgsql-general/2007-11/msg01193.php
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-11-26 07:38:37 | Re: replication in Postgres |
Previous Message | Gerhard Wiesinger | 2007-11-26 06:23:43 | Re: Tools for dumping pg_xlog, pg_clog, etc? |