oh and since pg_config end up in /usr/bin one also needs to symlink it to /usr/lib/postgresql/9.0/bin/ but: this leads to the next problem: postgres@newcollab :/home/adminlion$ cd /usr/lib/postgresql/9.0/bin/ 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 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) ok Trying to start old server .................ok Unable to start old postmaster with the command: "/usr/lib/postgresql/8.4/bin/pg_ctl" -l "/dev/null" -D "/var/lib/postgresql/8.4/main" -o "-p 5432 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000" start >> "/dev/null" 2>&1 Perhaps pg_hba.conf was not set to "trust".postgres@newcollab :/usr/lib/postgresql/9.0/bin$ exit both pg_bha have this: # Database administrative login by UNIX sockets local all postgres trust #ident # TYPE DATABASE USER CIDR-ADDRESS METHOD host egroupware egroupware 127.0.0.1/32 password # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: host all all 127.0.0.1/32 trust #md5 host all all 172.16.0.0/21 md5 # IPv6 local connections: host all all ::1/128 md5 any idea? ----------------original message----------------- From: "Bernhard Rohrer" graylion@xxxxxxxxx To: "Bernhard Schrader" bernhard.schrader@xxxxxxxxxxxx CC: pgsql-admin@xxxxxxxxxxxxxx Date: Wed, 23 Feb 2011 08:12:19 +0000 ------------------------------------------------- > 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 > -- -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin