Restoring DB - Why is there a dif from 2.17.03b?

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

Restoring DB - Why is there a dif from 2.17.03b?

Postby jockodundee » Mon Nov 02, 2009 4:58 am

I've loaded PT2 databases at least 500 times before.

When creating a DB backup from vers 2.17.03b, I create a .backup file and if I go to restore, PT2 looks for a .backup file and will load it, but in version 2.17.04g on a new computer, PT2 wants files of type pg_restore.exe to restore. Is this normal?

I have looked at the previous problems people have had with restoring. Of course, I am also having problems loading thru pgAdmin.

thanks.
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: Restoring DB - Why is there a dif from 2.17.03b?

Postby ptrack pat » Mon Nov 02, 2009 7:52 am

If you are using PostgreSQL 8.3 then browse to c:\program files\postgresql\8.3\bin and select the file from there.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Restoring DB - Why is there a dif from 2.17.03b?

Postby jockodundee » Fri Nov 06, 2009 5:29 pm

I thought PAD doesnt work with postgres version 3?
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: Restoring DB - Why is there a dif from 2.17.03b?

Postby ptrack pat » Fri Nov 06, 2009 5:41 pm

I don't think it does. If you installed 8.3 on the new PC you need to uninstall it and install 8.2 and then restore the databases again.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Restoring DB - Why is there a dif from 2.17.03b?

Postby jockodundee » Fri Nov 06, 2009 10:44 pm

I already did this.

Any idea why restoring a big database in PGAdmin, I am getting an error when restoring data for table "holdem-hand_histories": "pg_restore: [custom archiver] out of memory" even though I have 120 gb of free memory?
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: Restoring DB - Why is there a dif from 2.17.03b?

Postby ptrack pat » Sat Nov 07, 2009 12:11 am

There is no such table in PT2. If you are doing restoring PT3 databases you need to be posting these issues on that forum.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron