Page 1 of 1

Postgres 9 / Performance Tunning

PostPosted: Fri May 06, 2011 7:13 pm
by DanielP
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.

Re: Postgres 9 / Performance Tunning

PostPosted: Sat May 07, 2011 4:19 am
by WhiteRider
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.