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

On 23/09/12 11:48, Adrian Klaver wrote:
> On 09/23/2012 04:47 AM, ac@hsk.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.

Martin