X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E6F27D8D35
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Tue, 13 Sep 2005 11:22:06 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 76790-10
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Tue, 13 Sep 2005 14:22:00 +0000 (GMT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.177])
	by svr1.postgresql.org (Postfix) with ESMTP id 82345D8D05
	for <pgsql-general@postgresql.org>;
	Tue, 13 Sep 2005 11:21:59 -0300 (ADT)
Received: from h-67-103-122-2.snfccasy.covad.net [67.103.122.2]
	(helo=stromboli) by mrelayeu.kundenserver.de with ESMTP (Nemesis),
	id 0MKwtQ-1EFBfO1UxM-0005b2; Tue, 13 Sep 2005 16:21:46 +0200
From: "Simon Riggs" <simon@2ndquadrant.com>
To: "Tatsuo Ishii" <t-ishii@sra.co.jp>
Cc: <barry@e-rm.co.uk>, <pgsql-general@postgresql.org>
Subject: Re: Replication
Date: Tue, 13 Sep 2005 16:21:04 -0700
Message-ID: <KGEFLMPJFBNNLNOOOPLGIEOPCIAA.simon@2ndquadrant.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
In-Reply-To: <20050913.225402.39152157.ishii@sraoss.co.jp>
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:51320d06ba6b43864a3fe5d428030dbe
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.202 required=5 tests=[DATE_IN_FUTURE_06_12=1.202]
X-Spam-Level: *
X-Archive-Number: 200509/496
X-Sequence-Number: 83512


> From: Tatsuo Ishii [mailto:t-ishii@sra.co.jp]
> > You can use PITR to archive transaction logs to a second
> server that is
> > kept in standby mode.
> >
> > This will cope with any number of tables and cope with
> dynamic changes
> > to tables.
> >
> > This is fairly straightforward and very low overhead.
> > Set archive_command to a program that transfers xlog files to second
> > server.
> > Then set restore_command on the second server to a program
> that loops
> > until the next file is available.
> > Switchover time is low.
>
> I thought there are some issues of log based replication (I don't
> remeber details though). Have they been resolved recently?

Yes, currently log-file based replication is not recommended when the
transaction rate is either low or extremely variable.

I was regrettably unable to get a patch for that into 8.1

Best Regards, Simon Riggs