Re: PG_update to 9.0.4 in ubuntu lucid 64

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/pg_upgrade_dump_db.sql:24606: ERROR: column "name" in child table must be marked NOT NULL

There were problems executing "/usr/lib/postgresql/9.0/bin/psql" --set ON_ERROR_STOP=on --no-psqlrc --port 5432 --username "postgres" -f "/usr/lib/postgresql/9.0/bin/pg_upgrade_dump_db.sql" --dbname template1 >> "/dev/null"

does that mean line24606? it looks like manual edititng required ...

Thanks

Bernhard

----------------original message-----------------
From: "Bernhard Schrader" bernhard(dot)schrader(at)innogames(dot)de
To: "Bernhard Rohrer" graylion(at)sm-wg(dot)net
CC: pgsql-admin(at)postgresql(dot)org
Date: Wed, 23 Feb 2011 10:11:55 +0100
-------------------------------------------------


> 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(at)newcollab :/home/adminlion$ cd /usr/lib/postgresql/9.0/bin/
>> postgres(at)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"(dot)postgres(at)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(at)sm-wg(dot)net
>> To: "Bernhard Schrader" bernhard(dot)schrader(at)innogames(dot)de
>> CC: pgsql-admin(at)postgresql(dot)org
>> 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(dot)schrader(at)innogames(dot)de
>> > To: "Bernhard Rohrer" graylion(at)sm-wg(dot)net
>> > CC: pgsql-admin(at)postgresql(dot)org
>> > 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(at)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(at)postgresql(dot)org )
>> > To make changes to your subscription:
>> > http://www.postgresql.org/mailpref/pgsql-admin
>> >
>>
>> --
>>
>>
>>
>>
>>
>
>

--