Page 1 of 1

nothing works after postgresql uninstall and new install 8.3

PostPosted: Tue Jul 29, 2008 5:51 pm
by atum08
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

Re: nothing works after postgresql uninstall and new install 8.3

PostPosted: Wed Jul 30, 2008 4:38 am
by WhiteRider
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.

Re: nothing works after postgresql uninstall and new install 8.3

PostPosted: Wed Jul 30, 2008 5:46 am
by atum08
problem solved, i restored the old db and it works now

highfalutin