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(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.

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.