Exported PT3 database now what?

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Exported PT3 database now what?

Postby nelliesman93 » Thu Oct 23, 2008 8:27 am

I would like to do a full uninstall/reinstall. I have exported my PT3 database in database management. I would now like to backup my PostgreSQL database. I am still using 8.2.5 from PT2 and would like to go to 8.3. I tried to backup 8.2.5 using the 8.3 forum instructions but did not have success.

Thanks for the help.
nelliesman93
 
Posts: 115
Joined: Fri Jan 25, 2008 7:08 pm

Re: Exported PT3 database now what?

Postby WhiteRider » Thu Oct 23, 2008 8:42 am

Please see the Database / Postgres FAQ for info on backing up a DB.

Are you still using PT2?
8.3 does work with it, but there are a few complications setting it up, so if you're still using it you may be better to stick with 8.2 for now..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Exported PT3 database now what?

Postby nelliesman93 » Thu Oct 23, 2008 9:25 am

WhiteRider wrote:Please see the Database / Postgres FAQ for info on backing up a DB.

Are you still using PT2?
8.3 does work with it, but there are a few complications setting it up, so if you're still using it you may be better to stick with 8.2 for now..


I tried to use the information in the FAQ but it did not seem to work with 8.2. I am using PT3 but would like to uninstall/reinstall PT3 and upgrade from 8.2 to 8.3. My understanding is that the cache capability only works with 8.3.

Thanks.
nelliesman93
 
Posts: 115
Joined: Fri Jan 25, 2008 7:08 pm

Re: Exported PT3 database now what?

Postby WhiteRider » Thu Oct 23, 2008 10:43 am

Postgres 8.2 is supported by PT3, so the cache should work.
Have you had problems with it?

What error do you get when you try to create the backup?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Exported PT3 database now what?

Postby nelliesman93 » Thu Oct 23, 2008 11:25 am

WhiteRider wrote:Postgres 8.2 is supported by PT3, so the cache should work.
Have you had problems with it?

What error do you get when you try to create the backup?


No, I don't have issues but I thought I read in one of the posts that the cache will not work using PT3 and 8.2.

I tried this from the FAQ: Backing up a postgres database using PGAdmin III and I did not have this option so I tried the command prompt and received the following error:

[ img ]
nelliesman93
 
Posts: 115
Joined: Fri Jan 25, 2008 7:08 pm

Re: Exported PT3 database now what?

Postby WhiteRider » Thu Oct 23, 2008 11:37 am

The cache should work fine with 8.2.

In The pg_dump command you will have to put the filenames in quotes.
pg_dump -U "PokerTracker 3 Database" > "PokerTracker 3 Database.tar"
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Exported PT3 database now what?

Postby nelliesman93 » Thu Oct 23, 2008 6:13 pm

WhiteRider wrote:The cache should work fine with 8.2.

In The pg_dump command you will have to put the filenames in quotes.
pg_dump -U "PokerTracker 3 Database" > "PokerTracker 3 Database.tar"


ok, I input this: pg_dump -U postgres -Ft "PokerTracker 3 Database" > "PokerTracker 3 Database.tar"
and received this: pg_dump: [archiver (db)] connection to database "PokerTracker 3 Database" failed: FATAL: database "PokerTracer 3 Database" does not exist

I double checked the name of my DB and that is what it is.
nelliesman93
 
Posts: 115
Joined: Fri Jan 25, 2008 7:08 pm

Re: Exported PT3 database now what?

Postby WhiteRider » Fri Oct 24, 2008 3:59 am

Sorry, I missed out the 'postgres' bit:

Code: Select all
pg_dump -U postgres -Ft "PokerTracker 3 Database" > "PokerTracker 3 Database.tar"
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Exported PT3 database now what?

Postby nelliesman93 » Fri Oct 24, 2008 9:51 am

WhiteRider wrote:Sorry, I missed out the 'postgres' bit:

Code: Select all
pg_dump -U postgres -Ft "PokerTracker 3 Database" > "PokerTracker 3 Database.tar"


I did input the entire instruction but received this: pg_dump: [archiver (db)] connection to database "PokerTracker 3 Database" failed: FATAL: database "PokerTracer 3 Database" does not exist
nelliesman93
 
Posts: 115
Joined: Fri Jan 25, 2008 7:08 pm

Re: Exported PT3 database now what?

Postby WhiteRider » Fri Oct 24, 2008 9:54 am

Is that the correct name of your database?
Use the Database Management window to check.

I'll get someone else to have another look at this who knows more about postgres than me.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests