Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id ECC431337B4E for ; Wed, 23 Feb 2011 07:40:13 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 77818-04 for ; Wed, 23 Feb 2011 11:40:06 +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 01C071337B4A for ; Wed, 23 Feb 2011 07:40:05 -0400 (AST) Received: from collab.sm-wg.net (localhost [127.0.0.1]) by collab.sm-wg.net (Postfix) with ESMTP id 981702E7A45E; Wed, 23 Feb 2011 11:40:03 +0000 (GMT) Date: Wed, 23 Feb 2011 11:40:03 +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: X-Priority: 3 X-Mailer: PHPMailer 5.1 (phpmailer.sourceforge.net) X-Mailer: FeLaMiMail In-Reply-To: <1298452315.2227.0.camel@schrader-laptop> 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/203 X-Sequence-Number: 36842 Thanks that worked. :) After this and some more entertainment we are now here: Restoring database schema to new cluster psql:/usr/lib/postgresql/9.0/bin/p= g_upgrade_dump_db.sql:24606: ERROR: column "name" in child table must be ma= rked NOT NULL There were problems executing "/usr/lib/postgresql/9.0/bin/psql" --set ON_E= RROR_STOP=3Don --no-psqlrc --port 5432 --username "postgres" -f "/usr/lib/p= ostgresql/9.0/bin/pg_upgrade_dump_db.sql" --dbname template1 >> "/dev/null" does that mean line24606? it looks like manual edititng required ... Thanks Bernhard =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: Wed, 23 Feb 2011 10:11:55 +0100 ------------------------------------------------- =20 =20 > try to link both postgresql.conf to > your /var/lib/postgresql/8.3/main/postgresql.conf and 9.0/main >=20 >=20 > 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 t= o=20 >> /usr/lib/postgresql/9.0/bin/ >>=20 >> but: this leads to the next problem: >>=20 >> postgres@newcollab :/home/adminlion$ cd /usr/lib/postgresql/9.0/bin/=20 >> postgres@newcollab :/usr/lib/postgresql/9.0/bin$ ./pg_upgrade -b=20 >> /usr/lib/postgresql/8.4/bin/ -B /usr/lib/postgresql/9.0/bin/ -d=20 >> /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 >>=20 >> Unable to start old postmaster with the command:=20 >> "/usr/lib/postgresql/8.4/bin/pg_ctl" -l "/dev/null" -D=20 >> "/var/lib/postgresql/8.4/main" -o "-p 5432 -c autovacuum=3Doff -c=20 >> autovacuum_freeze_max_age=3D2000000000" start >> "/dev/null" 2>&1 >> Perhaps pg_hba.conf was not set to "trust".postgres@newcollab=20 >> :/usr/lib/postgresql/9.0/bin$ exit >>=20 >> both pg_bha have this: >>=20 >> # Database administrative login by UNIX sockets >> local all postgres trust #ident >>=20 >> # 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 >>=20 >> any idea?=20 >>=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:=20 >> http://ubuntuforums.org/showthread.php?t=3D1341411 >> >=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 yo= u >> >> 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 >> > --=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 >> --=20 >>=20 >>=20 >>=20 >>=20 >>=20 >=20 >=20 --=20