From: Bernhard Rohrer <graylion@sm-wg.net>
To: Bernhard Schrader <bernhard.schrader@innogames.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: PG_update to 9.0.4 in ubuntu lucid 64
Date: Wed, 23 Feb 2011 08:50:55 +0000
Message-ID: <1c27e5f5b9bcfa43df5c50c9b7a3ec03@collab.sm-wg.net> (raw)
In-Reply-To: <e8d57cc945d437e1e829f279adc15a36@collab.sm-wg.net>
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
>
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: graylion@sm-wg.net, bernhard.schrader@innogames.de
Subject: Re: PG_update to 9.0.4 in ubuntu lucid 64
In-Reply-To: <1c27e5f5b9bcfa43df5c50c9b7a3ec03@collab.sm-wg.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox