| From: | "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk> |
| Subject: | Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version(); |
| Date: | 2012-09-23 11:47:08 |
| Message-ID: | DDB26156-D4A3-4823-AE46-1C9BD90886D0@hsk.hk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Regards
Arthur
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafal Pietrak | 2012-09-23 13:18:44 | Re: RFE: Column aliases in WHERE clauses |
| Previous Message | Jasen Betts | 2012-09-23 07:13:29 | Re: Using psql -f to load a UTF8 file |