Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version - Mailing list pgsql-general

From John R Pierce
Subject Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
Date
Msg-id 4B8794A9.2040508@hogranch.com
Whole thread Raw
In response to Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List 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.




pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
Next
From: Greg Smith
Date:
Subject: Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version