Unable to execute query

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

Unable to execute query

Postby ToMz » Fri Feb 19, 2010 7:31 am

No more players in the lists.

Can't even choose my screenname anymore.

Image

Image

The story is that I was forced to format my system because I could'nt boot anymore, so I could'nt export my database but hopefully my postgres directory was on another partition.

I listened to some random who told me that I could just easily uninstall/reinstall postgres and copy/paste my old postgres "data" dir. :?

So now all I have is a 3GB data dir, please tell me that my database is still fixable please please. :cry:

I tried the reindexdb command thing but still doesn't work. :(
ToMz
 
Posts: 9
Joined: Fri Dec 18, 2009 11:46 pm

Re: Unable to execute query

Postby kraada » Fri Feb 19, 2010 9:44 am

Did you copy everything in that data directory? It looks like some of the files in the pg_xlog directory may be damaged or missing from the error you display. If that's the case I don't know that the database will be recoverable.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to execute query

Postby ToMz » Fri Feb 19, 2010 1:51 pm

Lol, wasn't expected this answer. :shock:

I directly copied and replaced the data dir by the old one, so I can't see how I could miss copying some files in it. :?
ToMz
 
Posts: 9
Joined: Fri Dec 18, 2009 11:46 pm

Re: Unable to execute query

Postby ToMz » Fri Feb 19, 2010 2:11 pm

I tried again, and now I'm getting this error when I start PT3 : "Unable to connect to database: PokerTracker3 database"

The reindexdb thing doesn't work either anymore :
Image

:cry:
ToMz
 
Posts: 9
Joined: Fri Dec 18, 2009 11:46 pm

Re: Unable to execute query

Postby ToMz » Fri Feb 19, 2010 2:42 pm

Sorry for multiple posts, the edit button seems to have disapeared on my old messages lol. :oops:

I'm currently trying the uninstall/reinstall everything disabling UAC, let you know if it helped. ;)
ToMz
 
Posts: 9
Joined: Fri Dec 18, 2009 11:46 pm

Re: Unable to execute query

Postby kraada » Fri Feb 19, 2010 2:47 pm

Ok, if that doesn't work, create a support ticket using this link and we'll get things sorted out for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to execute query

Postby ToMz » Fri Feb 19, 2010 3:15 pm

Doesn't work. :cry:
ToMz
 
Posts: 9
Joined: Fri Dec 18, 2009 11:46 pm

Re: Unable to execute query

Postby kraada » Fri Feb 19, 2010 4:14 pm

I'm not sure what you mean - just click that link, fill out the form and submit it and one of our support technicians will get back to you.
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 14 guests

cron