Message-ID: <4CD02260.3070508@blogg.se>
Date: Tue, 02 Nov 2010 15:38:24 +0100
From: =?UTF-8?B?Um9iZXJ0IEdyYXZzasO2?= <robert@blogg.se>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
	rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: reinstall postgreSQL same version while server up and
	running possible under linux ?
References: <AANLkTikGjHDw-Vut1WCM_4P4t6n47b4g99vfpru=fLJF@mail.gmail.com>
In-Reply-To: <AANLkTikGjHDw-Vut1WCM_4P4t6n47b4g99vfpru=fLJF@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Re-sending to list since I forgot to include it on reply.

On 2010-11-02 13.59, Gerhard Hintermayer wrote:
 > Sorry for posting this again, but my last post regarding this
 > problematic wasn't answered satisfyingly. (maybe I didn't find the
 > right words for my question ;-) )
 >
 >
 > is this (or a minor upgrade) a "safe" way to go under linux ? I'm on a
 > production system and I don't want to restart the DB server while the
 > factory is in production, but be sure that i'm prepared the next time
 > I'll do a restart. Of course I could wait for a factory shutdown on a
 > weekend, stop server, upgrade/reinstall and restart, but I'd prefer a

You can install multiple versions of PostgreSQL on Gentoo. Portage calls 
this SLOT[1].

 > "on the fly upgrade".

Depending on your definition here. You will need to restart your server 
at some point.

The options you have is dump/restore[2] or pg_upgrade[3].

 > (this is required due to a changed upstream library dependancy (major
 > perl upgrade) running gentoo)

Not sure what you are saying here.

-- 
Regards,
Robert "roppert" Gravsjö

1. http://www.gentoo.org/doc/en/handbook/handbook-x86.xml?part=2&chap=1
2. http://www.postgresql.org/docs/9.0/interactive/migration.html
3. http://www.postgresql.org/docs/9.0/interactive/pgupgrade.html