On Sun, 2007-11-25 at 23:38 +0100, Alexander Staubo wrote: > On 11/25/07, Glyn Astill <glynastill@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
