Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id C97DC632890
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 31 Aug 2010 07:50:36 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 51670-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 31 Aug 2010 10:50:20 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.affinitas.de (static.78.108.40.188.clients.your-server.de
	[188.40.108.78])
	by mail.postgresql.org (Postfix) with ESMTP id DF14F632693
	for <pgsql-admin@postgresql.org>; Tue, 31 Aug 2010 07:50:19 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mail.affinitas.de (Postfix) with ESMTP id 8A3CEC00759
	for <pgsql-admin@postgresql.org>; Tue, 31 Aug 2010 12:52:41 +0200 (CEST)
X-Virus-Scanned: Debian amavisd-new at mail.affinitas.de
Received: from mail.affinitas.de ([127.0.0.1])
	by localhost (mail.affinitas.de [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id zEaiuzBEQygi for <pgsql-admin@postgresql.org>;
	Tue, 31 Aug 2010 12:52:41 +0200 (CEST)
Received: from affinitas55.localnet (unknown [91.102.12.2])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.affinitas.de (Postfix) with ESMTPSA
	for <pgsql-admin@postgresql.org>; Tue, 31 Aug 2010 12:52:41 +0200 (CEST)
From: Jens Wilke <jens.wilke@affinitas.de>
Organization: Affinitas GmbH
To: pgsql-admin@postgresql.org
Subject: Re: multiple standby configuration
Date: Tue, 31 Aug 2010 12:50:21 +0200
User-Agent: KMail/1.12.2 (Linux/2.6.31-22-generic; KDE/4.3.2; x86_64; ; )
References: <4C7CCD1F.6010503@tech.sdb.it>
In-Reply-To: <4C7CCD1F.6010503@tech.sdb.it>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Message-Id: <201008311250.21281.jens.wilke@affinitas.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5
	tests=BAYES_20=-0.001
X-Spam-Level: 
X-Archive-Number: 201008/280
X-Sequence-Number: 35529

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 , =20

IIRC, this should be possible in 9.1

HTH,
Jens
=2D-=20
Affinitas GmbH  |  Kohlfurter Stra=DFe 41/43  |  10999 Berlin  |  Germany

Gesch=E4ftsf=FChrer: Lukas Brosseder, David Khalil, Kai Rieke, Christian Vo=
llmann
Eingetragen beim Amtsgericht Berlin, HRB 115958