David Ghedini

Linux, Java, Oracle, and PostgreSQL


David Ghedini

Tuesday Sep 11, 2012

PostgreSQL 9.2 Released

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.

Bookmark and Share



Comments:

Hi David,
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 #

Hi Ast,

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 #

Post a Comment:
  • HTML Syntax: Allowed

Main Menu

Built With

Search

Pages

LinkedIn

Technorati Profile

Add Technorati Favorite

Tag Cloud

Enciva Solutions

Navigation

Visitors

Sponsors

Feeds

Tag Cloud

VPS Hosting: 1Gbps Network