pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rex Mabry <rexmabry@yahoo.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: replica of database
Date: Thu, 11 Sep 2008 06:42:19 -0700 (PDT)
Message-ID: <327914.769.qm@web35904.mail.mud.yahoo.com> (raw)
In-Reply-To: <dcc563d10809102222i1e87b521jcd7f7929c0f84348@mail.gmail.com>

Version 8.3 has pg_standby.  Does anyone know how well that works for failover?

--- 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@hotmail.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...

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



      

view thread (14+ messages)  latest in thread

Message-ID: <327914.769.qm@web35904.mail.mud.yahoo.com>
Permalink:  ../327914.769.qm@web35904.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/327914.769.qm@web35904.mail.mud.yahoo.com

 · 

reply

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: rexmabry@yahoo.com
  Subject: Re: replica of database
  In-Reply-To: <327914.769.qm@web35904.mail.mud.yahoo.com>

* 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