Re: Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

Hi thanks,

I ran ps and found there were TWO postgresql

postgres 1124 0.0 0.1 45116 5480 ? S Sep23 0:01 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf
postgres 1133 0.0 0.0 45116 1984 ? Ss Sep23 0:03 postgres: writer process
postgres 1134 0.0 0.0 45116 1292 ? Ss Sep23 0:03 postgres: wal writer process
postgres 1135 0.0 0.0 45252 1560 ? Ss Sep23 0:01 postgres: autovacuum launcher process
postgres 1136 0.0 0.0 13284 1252 ? Ss Sep23 0:01 postgres: stats collector process
postgres 9429 0.0 0.1 43644 7140 ? S Sep23 0:00 /usr/lib/postgresql/9.2/bin/postgres -D /var/lib/postgresql/9.2/main -c config_file=/etc/postgresql/9.2/main/postgresql.conf
postgres 9431 0.0 0.0 43644 1272 ? Ss Sep23 0:00 postgres: checkpointer process
postgres 9432 0.0 0.0 43644 1408 ? Ss Sep23 0:00 postgres: writer process
postgres 9433 0.0 0.0 43644 1212 ? Ss Sep23 0:00 postgres: wal writer process
postgres 9434 0.0 0.0 44040 2148 ? Ss Sep23 0:00 postgres: autovacuum launcher process
postgres 9435 0.0 0.0 13868 1140 ? Ss Sep23 0:00 postgres: stats collector process

Regards
Arthur

On 24 Sep 2012, at 4:45 AM, Raymond O'Donnell wrote:

> On 23/09/2012 19:31, Martin Collins wrote:
>> On 23/09/12 11:48, Adrian Klaver wrote:
>>> On 09/23/2012 04:47 AM, ac(at)hsk(dot)hk wrote:
>>>> Hi,
>>>>
>>>> I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted
>>>> postgresql, it displayed my postgresql is 9.2 but when I log into
>>>> postgresql, show version, it is still 8.4.13, see a) and b)
>>>> below,
>>>>
>>>
>>> My guess is it installed a parallel version of Postgres for 9.2 and
>>> that 8.4.13 is listening to the default port of 5432 which is what
>>> you are connecting to. The 9.2 version is probably listening on
>>> another port(at a guess 5433). I would do a ps ax to confirm there is
>>> more than one instance of Postgres running.
>>
>> This is correct. Ubuntu (Debian really) installs the new vesion in
>> parallel and provides the pg_upgradecluster tool to migrate your old
>> data to the new version. Once you are satisfied that everything is
>> working you can use pg_dropcluster to remove the old data and you can
>> then uninstall 8.4.
>
> I've just discovered pg_lsclusters, another Debian tool, which lists all
> installed Postgres clusters, their ports, data directories, etc - really
> handy.
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod(at)iol(dot)ie
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general