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

On 2012-09-23 14:47, 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,
>
> a)
> * Restarting PostgreSQL 9.2 database server
>    ...done.

AFAIK,
postgres does not have any similar message like that :

  * Restarting PostgreSQL 9.2 database server
     ...done.


This message probably is from your OS upgrade tool, not from postgres.
>
> 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)
>
>

That is the true version that you have installed.


>
>
> Anything I have missed in my upgrade? please help.


Check logs of your installation tool, the problems can be different:
Like bug in your installation tool, bug in restarting part of that tool
unable to restart server.

Cheers,
C.