On 23/09/2012 19:31, Martin Collins wrote: > On 23/09/12 11:48, Adrian Klaver wrote: >> On 09/23/2012 04:47 AM, ac@xxxxxx 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, >>> >> >> 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. > > This is correct. Ubuntu (Debian really) installs the new vesion in > parallel and provides the pg_upgradecluster tool to migrate your old > data to the new version. Once you are satisfied that everything is > working you can use pg_dropcluster to remove the old data and you can > then uninstall 8.4. I've just discovered pg_lsclusters, another Debian tool, which lists all installed Postgres clusters, their ports, data directories, etc - really handy. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
