Postgres 9 / Performance Tunning

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

Postgres 9 / Performance Tunning

Postby DanielP » Fri May 06, 2011 7:13 pm

Stumbled across your performance tunning guide and decided to try, downloaded latest Postgres (9).

Realised Performance Tunning isn't available for 9 so tried the older version again.

They would not now install due to an error...something about interger numbers being in 64 bit strings.. I thought my computer was 32bit!?

Installed Postgres 9 again.

Now my databases are unreadable.

Whilst doing this was playing a couples of tables at the same time.

Somehow went a really hot streak and seem to have cured my downswing briefly!

Now I can't read the last 2 years of databases.. or work out how much I won in that session!!

I don't really care.. I'll just start fresh new summer databases with Postgres 9.

I don't always write in this style; it just happened; I had concision in mind.
DanielP
 
Posts: 9
Joined: Fri Mar 05, 2010 5:12 am

Re: Postgres 9 / Performance Tunning

Postby WhiteRider » Sat May 07, 2011 4:19 am

Are you sure you installed the same version when you went back to the old version? If you installed a different major version (e.g. 8.4.x instead of 8.3.x) then it won't be able to read your existing databases. When updating major versions you need to backup and restore your databases. Database / PostgreSQL FAQ
Also, did you uninstall v9, so that it isn't running anymore? If it's still running you may be connected to the "wrong" service.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 11 guests

cron