Re: upgrade from 8.0.3 to 8.1.0

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Dan The Man <bitsandbytes88(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: upgrade from 8.0.3 to 8.1.0
Date: 2005-11-08 17:23:49
Message-ID: Pine.LNX.4.64.0511080921230.13663@discord.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dan,

Sure, just bring it up in a different directory and have it listen on a
different port. You could either dump/restore to get the data over to it or
use a replication tool such as slony or mammoth to do the deed. The latter
method has the benefit of keeping it up to date while you poke around if you
have a database which gets written to during your switchover time.

On Tue, 8 Nov 2005, Dan The Man wrote:

> Hi,
> I have enough resources on my 3 postgresql servers to run more than one
> instance of postgres. Is there a way to keep my production db up and running
> in 8.0.3 while I also run 8.1.0 on the same server? Then, I could copy the
> data and support two databases until things looked good. Then, I'd shutdown
> 8.0.3.

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ludek Finstrle 2005-11-08 17:28:32 Re: upgrade from 8.0.3 to 8.1.0
Previous Message Moises Alberto Lindo Gutarra 2005-11-08 17:23:02 Re: upgrade from 8.0.3 to 8.1.0