Page 1 of 1

How do I update postgres?

PostPosted: Fri Mar 12, 2010 3:26 am
by 4nic8
How do I check the version I have and how do I upgrade?

Re: How do I update postgres?

PostPosted: Fri Mar 12, 2010 9:48 am
by kraada
In the newer versions of PT3 (Beta 30.7+) it says on the Database Management window in the upper right hand corner.

The upgrade directions change depending on what you're upgrading to and from.

Re: How do I update postgres?

PostPosted: Fri Mar 12, 2010 2:36 pm
by 4nic8
I have v8.2.13 in Win7. Also, if I need to backup up my database to upgrade I couldn't find out how anywhere.

Re: How do I update postgres?

PostPosted: Fri Mar 12, 2010 3:27 pm
by kraada
Yes, you'll need to backup to upgrade from the 8.2.x line to the 8.3.x or 8.4.x line - right now we are still recommending the 8.3.x line (particular 8.3.9 as it is the most recent).

You'll need to backup your database as explained in this tutorial then uninstall 8.2 and download and install the 8.3.9 pgInstaller from PostgreSQL's website. Install it, restore your database, and that should be all you need to do.

Re: How do I update postgres?

PostPosted: Fri Mar 12, 2010 7:11 pm
by 4nic8
"Note: From Beta 29 onwards PT3 has backup and restore functionality built in, so you no longer need to use these directions - I'll leave then here for reference only."

Quote form the backup tutorial. So there's no need to backup the database?

Re: How do I update postgres?

PostPosted: Fri Mar 12, 2010 7:48 pm
by kraada
You need to follow those directions to backup an 8.2.x database - the PT3 backup mechanism will only backup 8.3.x databases.

highfalutin