Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
Date: 2010-02-26 09:30:17
Message-ID: 4B8794A9.2040508@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albe Laurenz wrote:
> If you care about the data in the 7.3 data directory, you will
> have to migrate it: start a 7.3 server, export with 8.3's
> pg_dumpall, run 8.3's initdb, import the dump.
>

and thats not that easy with Redhat/Centos/Fedora/etc RPM installs, as
installing 8.x from RPM sources wiped out the 7.3 binaries

assuming you installed the PGDG rpms over the RH stock 7.3 RPMs, and you
don't particluarlly care for any 7.3 databases, you could try this...

# service stop postgresql -- (make sure everything is
stopped)
# mv /var/lib/pgsql/data /var/lib/pgsql/data-73
# service postgresql initdb
# service postgresql start

this will put aside the 7.3 postgres data for later consideration, and
create a new database cluster with the version you installed.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-02-26 09:43:56 Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
Previous Message Albe Laurenz 2010-02-26 08:27:13 Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version