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

Thanks Andreas for the info. I'm working on a development server right now, and currently I don't have any data loaded yet. As matter of fact, I was trying to load the database data from a dump file that generated by "pg_dump".
Here is the thing:
I've a /usr/bin/initdb -> this is probably from version 7.3 and other postgres related executable files.
I've a /usr/local/pgsql/bin/initdb -> this is probably from version 8.3.8. I think all the postgres related executable files are located in this directory. I like this organization much better in 8.3.8.
My question is what files should I delete from /usr/bin directory? Is there an automatic way to uninstall a particular version? I want to delete the 7.3 version and don't want to have multiple versions of postgres running on the same server.
If there is not an automatic way, then I can probably remove files like initdb, dropdb, createdb, psql and etc from the /usr/bin directory.
Or may be just specify the path when I run the initdb command "/usr/local/pgsql/bin/initdb" (other wise it would use /usr/bin/initdb)

Any thoughts?
Mary

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of A. Kretschmer
Sent: Thursday, February 25, 2010 11:04 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Two Versions of PostgreSQL Installed - How to uninstall one particular version

In response to Wang, Mary Y :
> Hi,
>
> I got this error:
> "-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start server starting
> -bash-2.05b$ FATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 8.3.8."
>
> I think I must have two versions of Postgres installed. How do I
> uninstall the 7.3 version? Do I need to do a manual uninstall by
> removing Postgres related files from /usr/bin and etc? Or is there an
> automatic way? The problem is that I'm unclear what files need to be
> removed. I think might also need to delete a file in the /etc/init.d
> directory.

I think, you have a problem ;-)

You have a data directory initialized by PostgreSQL version 7.3. Because of this, you need a running 7.3-Server to acces to this data. But you have installed 8.3.8.

You should now install a 7.3 - Server tu access to the data. Make a Backup of the data-directory before!

If the 7.3 - Server is running, you can make a Backup. You should make this Backup with the 8.3-Server (yes, you can have multiple versions installed on the same computer and the same time)

Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general