Re: PG_update to 9.0.4 in ubuntu lucid 64 - Mailing list pgsql-admin

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@sm-wg.net
> To: "Bernhard Schrader" bernhard.schrader@innogames.de
> CC: pgsql-admin@postgresql.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.schrader@innogames.de
> > To: "Bernhard Rohrer" graylion@sm-wg.net
> > CC: pgsql-admin@postgresql.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@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@postgresql.org )
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-admin
> >
>
> --
>
>
>
>
>