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.
Martin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
