| From: | Jens Wilke <jens(dot)wilke(at)affinitas(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: multiple standby configuration |
| Date: | 2010-08-31 10:50:21 |
| Message-ID: | 201008311250.21281.jens.wilke@affinitas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Spiegelberg | 2010-08-31 13:04:18 | General migration question |
| Previous Message | Silvio Brandani | 2010-08-31 09:36:31 | multiple standby configuration |