PDA

View Full Version : How to update postgreSQL EASY



bigbro69
09-29-2009, 12:37 PM
Hi.

I´m not used to scripting on any level. I can see that updating to 8.4 is not an easy task, and yes, i´m completely lost. Why is there not an "update" button to use?:confused: Damn, can anyone tell me the easy dummie way to udate postgreSQL?
:( Yep, i am a bit embarressed to ask!

netsrak
09-29-2009, 01:59 PM
There is no need to do the update if you have a running system.

The procedure would be:
- Backup database
- Export all handhistories as 2nd level backup.
- uninstall postgresql 8.3
- install postgresql 8.4
- create a new database with the same coding then the old one (SQL_ASCII i guess)
- restore the backup

bigbro69
10-01-2009, 09:40 AM
Normally its meant to be a good choice to upgrade because of improvements. I do have a running system, startet recently, and everything seems to run as intended. The upgrade is for unstable older versions and in case of systemcrash, i guess.:rolleyes: