On 09/23/2012 04:47 AM, a...@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. 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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
