David Ghedini
Tuesday Sep 11, 2012
PostgreSQL 9.2 has been released (9.2.0):
http://www.postgresql.org/docs/9.2/static/release-9-2.html
Update (September 16, 2012): Just update my blog to 9.2 using pg_upgrade.
So far, so good.
Posted at 04:07AM Sep 11, 2012 by David in PostgreSQL | Comments[2] | Tags: postgresql | Export to: |
I followed your excellent guide to install PG 1.9 on my CentOS box (http://www.davidghedini.com/pg/entry/installing_postgresql_9_on_cpanel), however I'd now like to upgrade to 9.2 ...would you know how best to go about that?
I tried running pg_upgrade - but it says command not found.
And /usr/pgsql-9.1/bin/pg_upgrade says I can't run it as root.
Any help greatly appreciated. Thanks.
Posted by Ast on December 18, 2012 at 09:31 PM CST #
You run pg_upgrade by first installing 9.2.
pg_upgrade is then run from 9.2 (as user postgres, NOT as root) using something like below :
-bash-3.2$ /usr/pgsql-9.2/bin/pg_upgrade -b /usr/pgsql-9.1/bin/ -B /usr/pgsql-9.2/bin/ -d /var/lib/pgsql/9.1/data/ -D /var/lib/pgsql/9.2/data
You will also need to update the symlinks you created for 9.1.
Thanks,
David
Posted by David Ghedini on December 22, 2012 at 07:17 PM CST #