PDA

View Full Version : Postgresql database question - update



jippyj
08-17-2010, 09:00 AM
Sorry if this has been asked before; google failed me on this one:

Is there any way to convert my database from postgresql 8.3 to 8.4 so i can keep the data?

Thanks

netsrak
08-17-2010, 10:30 AM
Nope, only backup/restore

jippyj
08-17-2010, 11:38 AM
sorry i dont quite understand i CAN backup and restore or i cant?

Thanks

netsrak
08-18-2010, 04:18 AM
One word before you install the update:
if you have a working postgresql 8.3 installation there is no need to update to 8.4
...


Yes, thats working but there is no automatic update procedure.

It works this way:
1. backup your database under Postgresql 8.3 via pgadminIII
1a. as a 2nd level backup: make sure you have all your hands in your archive (default c:\hmarchive) or export all hands from your database (+notes, + tourney summaries).
2. Uninstall Postgresql 8.3
3. Install Postgresql 8.4 (you can skip 2. if you install Postgresql 8.4 on port 8433, then you have both servers running but you have to adjust the connection info in Holdemmanager).
4. Create a new empty database in Postgresql 8.4 pgadminIII
5. Restore the backup into this database via pgadminIII
6. Start Holdemmanager and connect to the new postgresql 8.4 server