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
filesare 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/bindirectory.
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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of A. Kretschmer
Sent: Thursday, February 25, 2010 11:04 PM
To: pgsql-general@postgresql.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
accesto 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
havemultiple 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@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general