Skip site navigation (1) Skip section navigation (2)

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

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
Date: 2010-02-26 07:26:44
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC01EBE345E7@XCH-SW-06V.sw.nos.boeing.com (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

Responses

pgsql-general by date

Next:From: A. KretschmerDate: 2010-02-26 07:47:46
Subject: Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
Previous:From: A. KretschmerDate: 2010-02-26 07:04:26
Subject: Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group