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/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