From: Jens Wilke <jens.wilke@affinitas.de>
To: pgsql-admin@postgresql.org
Subject: Re: multiple standby configuration
Date: Tue, 31 Aug 2010 12:50:21 +0200
Message-ID: <201008311250.21281.jens.wilke@affinitas.de> (raw)
In-Reply-To: <4C7CCD1F.6010503@tech.sdb.it>
References: <4C7CCD1F.6010503@tech.sdb.it>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jens.wilke@affinitas.de
Subject: Re: multiple standby configuration
In-Reply-To: <201008311250.21281.jens.wilke@affinitas.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox