try to link both postgresql.conf to your /var/lib/postgresql/8.3/main/postgresql.conf and 9.0/main Am Mittwoch, den 23.02.2011, 08:50 +0000 schrieb Bernhard Rohrer: > 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
