nothing works after postgresql uninstall and new install 8.3

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

nothing works after postgresql uninstall and new install 8.3

Postby atum08 » Tue Jul 29, 2008 5:51 pm

hi, i have uninstalled postgresql 8.0 in order to install the new version 8.3.3.

after starting the service, installing the odbc driver and starting pt2, i receive the following error msgs:

"unable to connect to the database.
999 - sqlstate = im002
[microsoft][obdc driver manager] the datasourcename was not found and there were no driver given"

but i could choose at "odbc entry to use" the "postgresql unicode" and "encoding": "unicode", what didn't helped.

as i started the ring game stats, i received the 2nd error:

"datawindow error: database transaction information not avaible. call settrans or settransobject function."

i don't know what to do, i tried anything(like pg_hba.conf-> the option "trust" under "method", reboot, reinstall postgresql, etc.

pt2 is running with adminrights, like it did before.

lg

Image

Image

Image
atum08
 
Posts: 9
Joined: Sat May 17, 2008 10:19 am

Re: nothing works after postgresql uninstall and new install 8.3

Postby WhiteRider » Wed Jul 30, 2008 4:38 am

Databases are not compatible between major versions of postgres (e.g. 8.0 to 8.3) so you can't just continue to use the same database. You would need to backup the database in 8.0 and then restore it into 8.3, and this isn't a straighforward process.

Since you're using PT2, I'll move this to the PT2 section of the forum, though.
WhiteRider
Moderator
 
Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: nothing works after postgresql uninstall and new install 8.3

Postby atum08 » Wed Jul 30, 2008 5:46 am

problem solved, i restored the old db and it works now
atum08
 
Posts: 9
Joined: Sat May 17, 2008 10:19 am


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 2 guests

cron