PDA

View Full Version : PostgreSQL minor release upgrades



navi
10-09-2009, 11:29 AM
Hi i'm currently running PostgreSQL 8.3.3. I now see that PostgreSQL is at version 8.3.8. I would like to upgrade so as to be running the most secure and bug free version. Is it just a matter of stopping the service and running the installer?

Also I see in the release notes for 8.3.5 that users should "REINDEX all GiST indexes" after the upgrade and in the notes for 8.3.8 it states that "if you have any hash indexes on interval columns, you must REINDEX them after updating to 8.3.8". Are these steps necessary for Holdem Manager and if so how are they done?

Thanks in advance.

netsrak
10-09-2009, 12:06 PM
You can easily upgrade from 8.3.x to 8.3.x+1 but for safety make a backup before updating.

I don't think the other things are necessary but if you can do it via pgadmin->choose your database->maintenance -> Reindex

navi
10-09-2009, 12:09 PM
Thanks for your help. I'll do that.

navi
10-10-2009, 10:31 AM
I tried to install 8.3.8 over 8.3.3 but it would not complete the installation so I had to dump my database and uninstall PostgreSQL, reinstall using the exe from http://www.enterprisedb.com/products/pgdownload.do

The strange thing is now in pgAdmin I have two servers listed using the same port.

http://img63.imageshack.us/img63/5572/pgadmin.th.jpg (http://img63.imageshack.us/i/pgadmin.jpg/)

Is this normal? Do other users who used the enterprisedb installer have this?

fozzy71
10-10-2009, 01:33 PM
The multiple servers listed is a common issue. Not sure if it is a 'bug', but I have seen it many times and it doesnt seem to cause any problems AFAIK.

navi
10-10-2009, 02:46 PM
Ok I'll leave it as it is then. Thanks for the reassurance Fozzy.