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 :
root@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
