In response to Wang, Mary Y : > 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? I'm not familiar with RH, maybe someone else can better help you. But i think, you should use the packaging system, RPM, for software-(de)installation. 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general