How do I make PostgreSQL run quicker?
Please see this tutorial: Tuning PostgreSQL
Before making any changes to your PostgreSQL configuration please make a backup of the "C:\Program Files\PostgreSQL\8.3\data\postgresql.conf" file - if you make the wrong changes it can make performance worse and you may want to revert to the original settings.Can I have a PostgreSQL database on another networked computer? How do I do that?How To: Network PostgreSQL Database
See also this well-written post by Geert: PT3 on a Mac / PostgreSQL on a server
(useful for non-mac setups too).Can I have a PostgreSQL database on a separate drive in the same computer?
Details in this topic
, or this one
An alternative is to install PostgreSQL on another drive. You need to fully remove PostgreSQL from your PC (see below), then install to your chosen drive.Can I have PostgreSQL installed on a hotswap drive to use on two different computers?
Yes. Full tutorial guide is located Here
Or see this alternative method posted by a PT3 user: http://www.pokertracker.com/forums/viewtopic.php?f=17&t=20345&p=96577#p96460How do I move my database to another drive?
Please see this post by a PT3 user: http://www.pokertracker.com/forums/viewtopic.php?f=17&t=20345&p=96577#p96460How do I synchronize my databases on two computers?
There are a few options - the simplest is just to copy all the hand history files between computers after you play, and import them on both computers (or set up a shared folder and have both computers import the hand histories from it).
You could backup and restore the DBs, but that's quite long-winded.
If your computers are always networked, you could share a DB (but don't import from both at the same time). How To: Network PostgreSQL Database
Alternatively, you could set up a single DB on your laptop which would be shared by both (using the network link above), but then your laptop harddisk is probably smaller and slower, so this won't be so efficient.
You can also install PostgreSQL on a hot swap hard drive and then use it on two different computers (see here: Tutorial: 2 install of pt3, 1 database, no networking
).How do I completely uninstall PostgreSQL?How to reinstall PostgreSQLI have a copy of my PostgreSQL folder from before a harddisk failure or before I uninstalled PostgreSQL - how do I reconnect to my databases?
See How to reinstall PostgreSQL
1.) Save your "data" folder. You can find it in C:\Program Files\PostgreSQL\8.3.
2.) Uninstall PostgreSQL completely and delete everything under C:\Program Files\PostgreSQL\8.3. EXCEPT the data folder.
3.) Install PostgreSQL again, but untick "Initialize Database cluster".
4.) click on "connect" again and it should workI want to upgrade to a newer version of PostgreSQL.
If you are upgrading between major versions (e.g. 8.2 to 8.3) and you have existing databases, you will need to backup and restore any existing databases.
Until these functions are added to PT3, see this reply
Then follow the upgrade instructions with your new PostgreSQL installer.I already have PostgreSQL installed by another application, can I use that with PT3?
Yes, if you already have PostgreSQL installed by another application, you should be able to use it with PT3.
Most applications will have created the default user "postgres", but if yours didn't you will need to create the "postgres" user which PT3 needs.To create the postgres user.
You will need to know the username and password that the application created.
Open the PostgreSQL command line: Start -> Programs -> PostgreSQL -> Command Prompt
- Code: Select all
dropuser -U [third party PostgreSQL username] -W postgres
- Code: Select all
createuser -s -d -r -U [third party PostgreSQL username] -W postgres
Make sure you make a note of the password you choose as you will need it.
This will create the "postgres" user which should enable PT3 to connect to PostgreSQL.
... euser.htmlHow do I Purge and re-import all my hands?
First; make sure you have all your hand history files. You may have them in the 'processed' folder, but if not then you must export them; Database -> Database Management -> Export.
After this, if you have a registered copy then you can create a new database: Database -> Database Management -> New.
If not, you will have to empty your single DB. Database -> Database Management -> Purge.
Now you can run a Manual Import and import all your existing hand histories.Tutorial: Exporting SessionsTutorial: Purging SessionsDatabase Management & Maintenance GuideTutorial: Using Manual Import