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

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,
>
> a)
> * Restarting PostgreSQL 9.2 database server
> ...done.
>
>
> b)
> psql (8.4.13)
> Type "help" for help.
> postgres=# SELECT version();
> version
> --------------------------------------------------------------------------------------------------------------
> PostgreSQL 8.4.13 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 32-bit
> (1 row)
>
>
>
>
> Anything I have missed in my upgrade? please help.

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.

> Regards
> Arthur
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com