Upgrading side by side in Gentoo

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrading side by side in Gentoo
Date: 2008-11-12 17:46:36
Message-ID: gff4r5$r1t$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have separate production server running

"PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3.4.6 (Gentoo 3.4.6-r1, ssp-3.4.5-1.0,
pie-8.7.9)"

and want to upgrade this to something newer.
I can allow some hours of downtime for upgrade at night.

I have found Gentoo upgrade instructions here
http://hasno.info/2008/7/31/upgrading-to-postgresql-8-3-on-gentoo

I have no idea how PostgreSql is installed in this server, maybe it is
compiled from source.
So I'm afraid that using those instructions may corrupt the server so it
will no longer come up in morning and I'm not able to fix it due to lack of
allowed downtime and knowledge.

So I'm planning the following strategy:

1. Create backup copy in this 8.1.4
2. Stop postmaster
3. Install latest version of PostgreSql to separate directory
4. Restore to it from backup
5. If something fails, stop new and re-start old 8.1.4 postmaster.

The difficult point for me is (3).
How to install latest version in gentoo side-by side so that old version is
not touched?
In windows it is easy: I can select other directory from installer. How to
do same thing in this Gentoo ? I need also adminpack to read log files from
pgAdmin.

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-12 17:52:21 Re: [GENERAL] Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Previous Message Richard Huxton 2008-11-12 17:41:06 Re: [GENERAL] MAX_CONNECTIONS ??