Re: multiple standby configuration - Mailing list pgsql-admin

From Jens Wilke
Subject Re: multiple standby configuration
Date
Msg-id 201008311250.21281.jens.wilke@affinitas.de
Whole thread Raw
In response to multiple standby configuration  (Silvio Brandani <silvio.brandani@tech.sdb.it>)
List pgsql-admin
Am Dienstag 31 August 2010 11:36:31 schrieb Silvio Brandani:

> Is it possible to have multiple host destinations in the archive_command
> parameter of postgresql.conf to be able to mantain 2 standby datbase
> with write ahead log???

You have to write a shell script and run this as archive command.
The shell script can copy the wal files to multiple locations.

> is it possible to architect a cascading standby ,

IIRC, this should be possible in 9.1

HTH,
Jens
--
Affinitas GmbH  |  Kohlfurter Straße 41/43  |  10999 Berlin  |  Germany

Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christian Vollmann
Eingetragen beim Amtsgericht Berlin, HRB 115958

pgsql-admin by date:

Previous
From: Silvio Brandani
Date:
Subject: multiple standby configuration
Next
From: Greg Spiegelberg
Date:
Subject: General migration question