New PostgreSQL database

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

New PostgreSQL database

Postby duathlon » Thu Nov 13, 2008 12:35 am

I use postgreSQL with PT2 but the database has become very large and seems to slow down my computer. I'd like to start a new database but I can't figure out how to do it.
Thanks
duathlon
 
Posts: 70
Joined: Thu Mar 27, 2008 12:03 am

Re: New PostgreSQL database

Postby ptrack pat » Thu Nov 13, 2008 9:43 am

You have to use the File > Maintain Database Names window.
Click the Add button and enter a description and in the last field choose "Create new, empty Access database"
Click OK to save.
Now go to the Utilities > Convert Database window and convert the new db to PostgreSQL.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: New PostgreSQL database

Postby duathlon » Thu Nov 20, 2008 2:31 am

I've created a new dbase but it's still not working correctly. When I created the first new database I think I just copied the first, so I tried again and I think it's a totally brand new database. However, the import seems to be coming from the second database, and not the the third one (the one I want to use). Under maintain PT database I've selected the third one as the default but it's not coming up. How can I fix this?
Thanks
duathlon
 
Posts: 70
Joined: Thu Mar 27, 2008 12:03 am

Re: New PostgreSQL database

Postby duathlon » Thu Nov 20, 2008 2:51 am

Problem fixed.
I closed and restarted PT2 and then it started importing from the right DB. I also had to remember to switch to the correct DB in PAH.
duathlon
 
Posts: 70
Joined: Thu Mar 27, 2008 12:03 am


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 22 guests

cron