Installing Postgres after install PT3 without Postgres?
Join Date: Jan 2008
Posts: 39
Hey,
I have PostgreSQL running on a Linux server at my home and have PT3 on a XP laptop which works without problems, however, I'm looking to be able to use PT3 when I am away from home and my Linux server.
I would love to be able to install PostgreSQL onto my lap and export/import my existing database onto my laptop.
Question:
How do I go about installing PostgreSQL onto my laptop after installing PT3 without PostgreSQL installer script? Just download "PT3 with PostgreSQL" or can I just grab PostgreSQL from "http://www.postgresql.org/" site and install and be ready to roll?
I'm familiar how to setup PT3 to use the local database and how to export/import the existing database.
Question:
Is their an easy way to sync both databases servers so they mirror each other?
What if I use my Linux server database, using PT3 on my XP tower unit, then I leave the house and use my laptop, PT3 and local PostgreSQL database. Would I have to export laptop database, import into Linux database and vise-versa?
When exporting/importing, do the records in the database remain as new records are imported?
Thanks.
Jeff
Last edited by zbadone; 01-22-2009 at 12:56 PM.
Reason: Grammer corrections
See our Commercial Software thread
Join Date: May 2005
Posts: 6,489
The "Without" version is identical to the "With" version, just lacking the PostgreSQL installer. You can grab it from Postgres's website and install it manually and it'll work fine; we bundle it to reduce overhead for new users, but you sound like you should be able to handle the installation no problem.
There isn't an easy way to set up database mirroring as far as I'm aware short of reimporting all hands in both places. If you're not away from your house often that might not be that tedious though to manually import all hands while away when you get home and just backing up your postgresql databases on your linux server and restoring them to your laptop before you go on the road again (assuming you play at home more than away, if you play equally on both just importing processed hands is probably easiest).
I'm not sure what you mean by "do the records remain as new records are imported" -- importing more information never deletes or damages old information, and importing duplicates does not cause any problems.