How do I update postgres?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

How do I update postgres?

Postby 4nic8 » Fri Mar 12, 2010 3:26 am

How do I check the version I have and how do I upgrade?
4nic8
 
Posts: 28
Joined: Wed Dec 09, 2009 3:22 pm

Re: How do I update postgres?

Postby kraada » Fri Mar 12, 2010 9:48 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: How do I update postgres?

Postby 4nic8 » Fri Mar 12, 2010 2:36 pm

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.
4nic8
 
Posts: 28
Joined: Wed Dec 09, 2009 3:22 pm

Re: How do I update postgres?

Postby kraada » Fri Mar 12, 2010 3:27 pm

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: How do I update postgres?

Postby 4nic8 » Fri Mar 12, 2010 7:11 pm

"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?
4nic8
 
Posts: 28
Joined: Wed Dec 09, 2009 3:22 pm

Re: How do I update postgres?

Postby kraada » Fri Mar 12, 2010 7:48 pm

You need to follow those directions to backup an 8.2.x database - the PT3 backup mechanism will only backup 8.3.x databases.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron
highfalutin