EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Upgrade from 8.4 to 9.0 version help  XML

Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Author Message
ravalon_tin_it

Member

Joined: 16 Sep 2009 10:09:49
Messages: 74
Offline

Hello, i read 9.0 release announcements... in release notes i could read some difficult for upgade from 8.4 version....

Some notes say that "=>" are deprecated and other differences... i read many steps for upgrade as use Pg_upgrade or change manually many parameters...stop server, copy data ecc.ecc...

The installer cannot do alone the upgrade ?

Someone could explain me the step for a secure upgrade ??

Thanks
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 518
Offline

For upgrade of PG8.4 to PG9.0, you can use pg_upgrade binary.




Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
ravalon_tin_it

Member

Joined: 16 Sep 2009 10:09:49
Messages: 74
Offline

ehm......could you write me an example please ?? i'm not practice in this manual operation....
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 518
Offline

Here is a document of pg_upgrade, which has example:
http://www.postgresql.org/docs/9.0/interactive/pgupgrade.html

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
ravalon_tin_it

Member

Joined: 16 Sep 2009 10:09:49
Messages: 74
Offline

i don't understand if i need to manual upgrade....

i could read "If you are using a version-specific installation directory, e.g. /opt/PostgreSQL/8.4, you do not need to move the old cluster. The one-click installers all use version-specific installation directories."

I use the windows .exe installation with installer, i have the 8.4.x version installed in c:\programmi\postgresql\8.4 directory... need i to upgrade manually ???

This message was edited 1 time. Last update was at 26 Sep 2010 11:12:20

 
Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Go to:   
Powered by JForum 2.1.8 © JForum Team