From: Khangelani Gama <kgama@argility.com>
To: Kevin Grittner <kgrittn@ymail.com>
To: pgsql-admin@postgresql.org
Subject: Re: upgrading postgres 7.3.4 to 9.1.9
Date: Tue, 5 Aug 2014 06:23:46 +0200
Message-ID: <ec3c2eb760f4c84c503ef779b8c9f8d0@mail.gmail.com> (raw)
In-Reply-To: <1407176358.38816.YahooMailNeo@web122301.mail.ne1.yahoo.com>
References: <bf801eb082936b7671c4f7dfb26beec3@mail.gmail.com>
<1407159008.1433.YahooMailNeo@web122302.mail.ne1.yahoo.com>
<aa7e0dcc7e1aba50789a3661b6d67bb6@mail.gmail.com>
<1407176358.38816.YahooMailNeo@web122301.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> Can I try the following , I just don’t want to break other databases
> already running on postgres9
>
> Stop all instances from running
>
> ./configure --with-perl --prefix=$PATH Gmake Gmake install
>
> And then create an instance, and then pg_restore.
Personally, I would get that new build in a new directory, make sure that it
works with a PITR restore (or directory tree copy while the database is
stopped) of one of the other 9.1 clusters, and make sure you can CREATE
EXTENSION plperl before trying to convert this 7.3 database. Then you can
move all the old clusters over to the new executable by updating your
service script to point to the new executable running stop and then running
start. (I have found that restart does not work for a minor upgrade -- a
separate stop -w and start -w is needed.)
Thanks Kevin,
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: kgama@argility.com, kgrittn@ymail.com
Subject: Re: upgrading postgres 7.3.4 to 9.1.9
In-Reply-To: <ec3c2eb760f4c84c503ef779b8c9f8d0@mail.gmail.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