and here is the answer: http://ubuntuforums.org/showthread.php?t=1341411 libpq-dev is what is needed ----------------original message----------------- From: "Bernhard Schrader" bernhard.schrader@xxxxxxxxxxxx To: "Bernhard Rohrer" graylion@xxxxxxxxx CC: pgsql-admin@xxxxxxxxxxxxxx Date: Tue, 22 Feb 2011 19:52:19 +0100 ------------------------------------------------- > it was missing in my installations too, let me check what i installed.. > > its for debian: > libpq5, libpq-dev, libpq5/lenny-backports-sloppy, > postgresql-client-common/lenny-backports, > postgresql-common/lenny-backports, > libpq-dev/lenny-backports-sloppy, > postgresql-9.0 postgresql postgresql-contrib-9.0 postgresql-client-9.0 > postgresql-server-dev-9.0 > > > it's a little bit overkill, but there were so many dependencies if you > want to upgrade correctly. the lenny-backports-sloppy packets are the > newest packets you can get i think. don't know your repo. maybe it > helped you. > and yes, the order in which i installed all this packet is like above. > it was really necessary this way :D > > greetz > Bernhard > > Am Dienstag, den 22.02.2011, 18:41 +0000 schrieb Bernhard Rohrer: >> according to aptitude contrib is installed. But PGAdmin is also >> complaining about missing modules. could it be that some stuff is >> missing in Ubuntu? >> >> Version BTW is 9.0.3-1 >> >> On 22/02/11 17:07, Bernhard Schrader wrote: >> > did you installed the postgresql-9.0 contrib modules? >> > >> > Am Dienstag, den 22.02.2011, 14:05 +0000 schrieb Bernhard Rohrer: >> >> Hi guys >> >> >> >> I am getting the following: >> >> >> >> postgres@newcollab :/usr/lib/postgresql/9.0/bin$ ./pg_upgrade >> >> -b /usr/lib/postgresql/8.4/bin/ -B /usr/lib/postgresql/9.0/bin/ >> >> -d /var/lib/postgresql/8.4/main -D /var/lib/postgresql/9.0/main >> >> sh: /usr/lib/postgresql/9.0/bin/pg_config: not found >> >> Performing Consistency Checks >> >> ----------------------------- >> >> Checking old data directory (/var/lib/postgresql/8.4/main) ok >> >> Checking old bin directory (/usr/lib/postgresql/8.4/bin) ok >> >> Checking new data directory (/var/lib/postgresql/9.0/main) ok >> >> Checking new bin directory (/usr/lib/postgresql/9.0/bin) >> >> check for pg_config failed - No such file or directory >> >> >> >> #locate pg_config >> >> /usr/share/locale-langpack/en_GB/LC_MESSAGES/pg_config-8.4.mo >> >> /usr/share/postgresql-common/t/140_pg_config.t >> >> >> >> errrm, what? what is it looking for? >> >> >> >> Thanks >> >> >> >> Bernhard >> >> >> >> >> __________________________________________________________________ >> ____ >> >> >> > >> > >> >> > > > > > -- ------------- Bernhard Rohrer Consulting 529 Howth Road Dublin 5, Ireland +353 87 7907 134 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin