Yes, you are right. I didn't stop the server before un-installing. Not good. I should have thought about that. Not sure how to repair that though.
running pg_config : r...@ubuntu-904-jaunty-64-minimal:/opt/PostgreSQL/EnterpriseDB-TuningWizard# pg_config BINDIR = /usr/lib/postgresql/8.3/bin DOCDIR = /usr/share/doc/postgresql-doc-8.3 INCLUDEDIR = /usr/include/postgresql PKGINCLUDEDIR = /usr/include/postgresql INCLUDEDIR-SERVER = /usr/include/postgresql/8.3/server LIBDIR = /usr/lib PKGLIBDIR = /usr/lib/postgresql/8.3/lib LOCALEDIR = /usr/share/locale MANDIR = /usr/share/postgresql/8.3/man SHAREDIR = /usr/share/postgresql/8.3 SYSCONFDIR = /etc/postgresql-common PGXS = /usr/lib/postgresql/8.3/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--build=x86_64-linux-gnu' '--prefix=/usr' '--includedir=/usr/include' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var' '--libexecdir=/usr/lib/postgresql-8.3' '--disable-maintainer-mode' '--disable-dependency-tracking' '--srcdir=.' '--mandir=/usr/share/postgresql/8.3/man' '--with-docdir=/usr/share/doc/postgresql-doc-8.3' '--sysconfdir=/etc/postgresql-common' '--datadir=/usr/share/postgresql/8.3' '--bindir=/usr/lib/postgresql/8.3/bin' '--includedir=/usr/include/postgresql/' '--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety' '--enable-debug' '--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-krb5' '--with-gssapi' '--with-openssl' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-ossp-uuid' '--with-gnu-ld' '--with-tclconfig=/usr/lib/tcl8.5' '--with-tkconfig=/usr/lib/tk8.5' '--with-includes=/usr/include/tcl8.5' '--with-system-tzdata=/usr/share/zoneinfo' '--with-pgport=5432' 'CFLAGS=-g -O2 -g -Wall -O2 -fPIC' 'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,--as-needed' 'CC=cc' 'CPPFLAGS=' 'build_alias=x86_64-linux-gnu' CC = cc CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/tcl8.5 CFLAGS = -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g CFLAGS_SL = -fpic LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm VERSION = PostgreSQL 8.3.7 It definetly points to the old version (8.3 .. why is 8.3 still in the ubuntu package manager btw...?) .. >> locate pg_config /opt/PostgreSQL/8.4/bin/pg_config /opt/PostgreSQL/8.4/include/ecpg_config.h /opt/PostgreSQL/8.4/include/pg_config.h /opt/PostgreSQL/8.4/include/pg_config_manual.h /opt/PostgreSQL/8.4/include/pg_config_os.h /opt/PostgreSQL/8.4/include/postgresql/server/pg_config.h /opt/PostgreSQL/8.4/include/postgresql/server/pg_config_manual.h /opt/PostgreSQL/8.4/include/postgresql/server/pg_config_os.h /opt/PostgreSQL/8.4/share/man/man1/pg_config.1 /usr/bin/pg_config /usr/share/man/man1/pg_config.1.gz >> echo $PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games I am guessing I should delete the pg_config (or else there would be a conflict, right?) in the /usr/bin and run : >> export PATH=/opt/PostgreSQL/8.4/bin/:$PATH is that correct? ( I learned from you other message :) ) Is there other things that could have been destroyed by the bad un-installment other than pg_config or was that it ? Thanks allot / Jennifer
