From: Robert Gravsjö <robert@blogg.se>
To: pgsql-admin@postgresql.org
Subject: Re: reinstall postgreSQL same version while server up and running possible under linux ?
Date: Tue, 02 Nov 2010 15:38:24 +0100
Message-ID: <4CD02260.3070508@blogg.se> (raw)
In-Reply-To: <AANLkTikGjHDw-Vut1WCM_4P4t6n47b4g99vfpru=fLJF@mail.gmail.com>
References: <AANLkTikGjHDw-Vut1WCM_4P4t6n47b4g99vfpru=fLJF@mail.gmail.com>
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
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: robert@blogg.se
Subject: Re: reinstall postgreSQL same version while server up and running possible under linux ?
In-Reply-To: <4CD02260.3070508@blogg.se>
* 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