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-ow...@postgresql.org [mailto:pgsql-general-ow...@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 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
