Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id ED87E64FD01
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 11 Sep 2008 10:42:27 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 22821-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 11 Sep 2008 10:42:21 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web35904.mail.mud.yahoo.com (web35904.mail.mud.yahoo.com
	[66.163.179.188])
	by postgresql.org (Postfix) with SMTP id 9787664FCD7
	for <pgsql-admin@postgresql.org>; Thu, 11 Sep 2008 10:42:21 -0300 (ADT)
Received: (qmail 879 invoked by uid 60001); 11 Sep 2008 13:42:19 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=ksA1QfJyuRTj0r5mDbaBDac3tbBgqYGfYxd3CtVnWd1iabUTdztlS2R/x+537I2BN/uDYJgkg77CjD0L60RvvbC1KxCcwKwl6LRX7erDvHgdR8Crq+2Le/fGX3qQrYXvG3jUiuyatNERDe+SBLvUMKjui30vUv5UufcwsdgJUBg=;
X-YMail-OSG: 
 Dl1E.k8VM1kavHBwEt9iTC13QnG1Hfj5a0RpXAk3srGRN_1lINKmipxadfFz_jyz_k3aT6NkbTUlR5FmtRGgsz_VPqx4fK1WfQE.G0tAPCErVvHyQagP9Hg8rAPWZVrBrIxJhiK8bCmh7hmnDW45kTyy
Received: from [199.200.10.52] by web35904.mail.mud.yahoo.com via HTTP;
	Thu, 11 Sep 2008 06:42:19 PDT
X-Mailer: YahooMailWebService/0.7.218.2
Date: Thu, 11 Sep 2008 06:42:19 -0700 (PDT)
From: Rex Mabry <rexmabry@yahoo.com>
Reply-To: rexmabry@yahoo.com
Subject: Re: replica of database
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <dcc563d10809102222i1e87b521jcd7f7929c0f84348@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-80018046-1221140539=:769"
Message-ID: <327914.769.qm@web35904.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.9 tagged_above=0 required=5 tests=FS_REPLICA=1.179,
	HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72
X-Spam-Level: *
X-Archive-Number: 200809/95
X-Sequence-Number: 30188

--0-80018046-1221140539=:769
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Version=A08.3 has pg_standby.=A0 Does anyone know how well that works for f=
ailover?

--- On Thu, 9/11/08, Scott Marlowe <scott.marlowe@gmail.com> wrote:

From: Scott Marlowe <scott.marlowe@gmail.com>
Subject: Re: [ADMIN] replica of database
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: "Aftab Alam" <AAlam@tsrdarashaw.com>, "Vishal Arora" <aroravishal22@hot=
mail.com>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Thursday, September 11, 2008, 12:22 AM

On Wed, Sep 10, 2008 at 10:52 PM, Joshua D. Drake <jd@commandprompt.com>
wrote:
> Aftab Alam wrote:
>>
>> Yes ,I want a replica of my db so that I can use it as failover
>>
>>
>> Version 7.3 linux AS release 4 update 6
>
> Version 7.3 is end of life and I don't know of *any* of the
replication
> technologies that will work with it.

I think older versions of slony can talk to it, but I'd only use that
to upgrade in place to 8.3.  I'm pretty sure you'd have to make a stop
at 8.0 or 8.1 along the way...

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
=0A=0A=0A      
--0-80018046-1221140539=:769
Content-Type: text/html; charset=us-ascii

<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Version&nbsp;8.3 has pg_standby.&nbsp; Does anyone know how well that works for failover?<BR><BR>--- On <B>Thu, 9/11/08, Scott Marlowe <I>&lt;scott.marlowe@gmail.com&gt;</I></B> wrote:<BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">From: Scott Marlowe &lt;scott.marlowe@gmail.com&gt;<BR>Subject: Re: [ADMIN] replica of database<BR>To: "Joshua D. Drake" &lt;jd@commandprompt.com&gt;<BR>Cc: "Aftab Alam" &lt;AAlam@tsrdarashaw.com&gt;, "Vishal Arora" &lt;aroravishal22@hotmail.com&gt;, "pgsql-admin@postgresql.org" &lt;pgsql-admin@postgresql.org&gt;<BR>Date: Thursday, September 11, 2008, 12:22 AM<BR><BR><PRE>On Wed, Sep 10, 2008 at 10:52 PM, Joshua D. Drake &lt;jd@commandprompt.com&gt;
wrote:
&gt; Aftab Alam wrote:
&gt;&gt;
&gt;&gt; Yes ,I want a replica of my db so that I can use it as failover
&gt;&gt;
&gt;&gt;
&gt;&gt; Version 7.3 linux AS release 4 update 6
&gt;
&gt; Version 7.3 is end of life and I don't know of *any* of the
replication
&gt; technologies that will work with it.

I think older versions of slony can talk to it, but I'd only use that
to upgrade in place to 8.3.  I'm pretty sure you'd have to make a stop
at 8.0 or 8.1 along the way...

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
</PRE></BLOCKQUOTE></td></tr></table><br>

      
--0-80018046-1221140539=:769--