Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 763141337B95 for ; Wed, 23 Feb 2011 04:51:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 78414-01 for ; Wed, 23 Feb 2011 08:50:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from collab.sm-wg.net (collab.sm-wg.net [86.43.106.231]) by mail.postgresql.org (Postfix) with ESMTP id 742E81337B4A for ; Wed, 23 Feb 2011 04:50:58 -0400 (AST) Received: from collab.sm-wg.net (localhost [127.0.0.1]) by collab.sm-wg.net (Postfix) with ESMTP id 486A42E778B3; Wed, 23 Feb 2011 08:50:55 +0000 (GMT) Date: Wed, 23 Feb 2011 08:50:55 +0000 To: Bernhard Schrader From: Bernhard Rohrer Cc: pgsql-admin@postgresql.org Subject: Re: PG_update to 9.0.4 in ubuntu lucid 64 Message-ID: <1c27e5f5b9bcfa43df5c50c9b7a3ec03@collab.sm-wg.net> X-Priority: 3 X-Mailer: PHPMailer 5.1 (phpmailer.sourceforge.net) X-Mailer: FeLaMiMail In-Reply-To: Organization: Bernhard Rohrer Consulting MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/201 X-Sequence-Number: 36840 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/ postgr= es@newcollab :/usr/lib/postgresql/9.0/bin$ ./pg_upgrade -b /usr/lib/postgre= sql/8.4/bin/ -B /usr/lib/postgresql/9.0/bin/ -d /var/lib/postgresql/8.4/mai= n -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=3Doff -c autovacuum_freeze_max_age=3D2000000000" start >> "/dev= /null" 2>&1 Perhaps pg_hba.conf was not set to "trust".postgres@newcollab :/usr/lib/pos= tgresql/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?=20 ----------------original message----------------- From: "Bernhard Rohrer" graylion@sm-wg.net=20 To: "Bernhard Schrader" bernhard.schrader@innogames.de=20 CC: pgsql-admin@postgresql.org=20 Date: Wed, 23 Feb 2011 08:12:19 +0000 ------------------------------------------------- =20 =20 > and here is the answer: http://ubuntuforums.org/showthread.php?t=3D134141= 1 >=20 > libpq-dev is what is needed >=20 > ----------------original message----------------- > From: "Bernhard Schrader" bernhard.schrader@innogames.de=20 > To: "Bernhard Rohrer" graylion@sm-wg.net=20 > CC: pgsql-admin@postgresql.org=20 > Date: Tue, 22 Feb 2011 19:52:19 +0100 > ------------------------------------------------- >=20 >=20 >> it was missing in my installations too, let me check what i installed.. >>=20 >> 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=20 >> postgresql-client-9.0 >> postgresql-server-dev-9.0 >>=20 >>=20 >> 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 >>=20 >> greetz >> Bernhard >>=20 >> Am Dienstag, den 22.02.2011, 18:41 +0000 schrieb Bernhard Rohrer: >>> according to aptitude contrib is installed. But PGAdmin is also=20 >>> complaining about missing modules. could it be that some stuff is=20 >>> missing in Ubuntu? >>>=20 >>> Version BTW is 9.0.3-1 >>>=20 >>> 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=20 >>> /usr/lib/postgresql/9.0/bin/ >>> >> -d /var/lib/postgresql/8.4/main -D=20 >>> /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 >>> >>=20 >>> /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 >>> >> >>> >>=20 >>>=20 >>> ________________________________________________________________ >>> __ >>> ____ >>> >> >>> > >>> > >>>=20 >>>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >=20 > --=20 > ------------- > Bernhard Rohrer Consulting > 529 Howth Road > Dublin 5, Ireland >=20 > +353 87 7907 134 >=20 >=20 > --=20 > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >=20 --=20