PostgreSQL, multiple computers

[GulahPapyrus]

Hello,
I recently made the switch to postgreSQL 8.3 from Access for PT2 and PTO, and installed Beta 9 of PT3...everything is working great under vista x64 and I have a few questions. I regularly play on two computers, my desktop and laptop. I plan on datamining full time with the desktop, and would like to set up my postgreSQL on my laptop to somehow be able to update using my desktop's database. This update would be done sometimes using a VPN connection, so copying the databases in their entirety would be a time and bandwidth consuming task that I would like to avoid. PosgreSQL seems very powerful, and I imagine there is some bandwidth efficient way of doing a DB update by connecting to the desktop's DB server. Any ideas? Even better, is a two-way update possible, creating a database that incorporates changes made by the laptop and desktop? What happens if my database contains a hand twice, once datamined and once played? I will have remote control over my desktop also.

Thank you very much, I love all the products and support.

[ptrack pat]

I don't support this setup but it is possible to setup PostgreSQL so that each computer can access/update the same database (although they should NEVER BE IMPORTING AT THE SAME TIME), see here for details...
archives/PT2/viewtopic.php?t=15294

PT will not import the same hand into the database more than once.

[GulahPapyrus]

Thanks for the link Pat, looks like a good starting place for more learning.

If PT imports a hand as an observer, can i later reimport the hand with hole card information? Is the database updated, or do I have to purge something? I use PokerEV, so hole card information is quite important to me.

Thanks again

[ptrack pat]

Once a hand is imported nothing else about that hand will import because it's skipped altogether. So if an observed hand is imported first without the hole cards then there is nothing you can do except delete the session that the hand was part of (Utilities > Database Maintenance and Options window) and then reimport the file that has the hand in it with the hole cards listed.

[eyedol]

Is it possible to have the database on a shared network drive? (the external drive is connected to the routers storage link)

This way I could play on either my desktop or laptop and don't have to care about the other computer being on.

Thanks,

[ptrack pat]

PostgreSQL is going to have to be installed on both computers.

When you do the install you would have to tell it you want the "Data Folder" to be on this external hard drive.

Once it's working on one computer, you would install it on the other computer and tell it the data folder on the external drive. HOWEVER, since the db is already created from the other computer when you get to the window that has "Initialize database cluster" at the top left corner, uncheck that box and click the next button.

In theory this should work, I've never done it myself to know if it really will work.