Having PT3 on two computers

[kraada]

If you are going to only use the database from your desktop, you don't need PostgreSQL installed on your laptop so you could just download the Upgrade version.

Configuring your desktop to allow anybody to connect to PostgreSQL will take a bit more work; you'll need to make sure your router forwards port 5432 to the desktop. You'll need to know the external IP address of your desktop (go here and it will tell you). You also need to configure your pg_hba.conf with a slightly different line. You'll want to use 0.0.0.0/0 and make sure you use md5 there, not trust. If you used trust there anybody anywhere on the internet could log into your PostgreSQL database without a password.

Then you connect to your desktop from your laptop using the external IP address and it should work.

[airfull]

Configuring your desktop to allow anybody to connect to PostgreSQL will take a bit more work; you'll need to make sure your router forwards port 5432 to the desktop. You'll need to know the external IP address of your desktop (go here and it will tell you). You also need to configure your pg_hba.conf with a slightly different line. You'll want to use 0.0.0.0/0 and make sure you use md5 there, not trust. If you used trust there anybody anywhere on the internet could log into your PostgreSQL database without a password.

Then you connect to your desktop from your laptop using the external IP address and it should work.

Wow it's complicated. Yes i'm a noob!!
I don't if i can mak all this things.
There's something i did'nt understood. Do you mean my desktop should be ON while i'm playing at my parents home for example ?
Is it possible to synchronise the database on each computer before i play on it ?

[kraada]

Yes, if you're going to use your desktop as a PostgreSQL server you would need to leave it on. Otherwise you wouldn't be able to get to the data.

You can synchronize things, but not automatically. What you'd need to do then is copy the hand history files after you finish playing to your other computer and import them manually. It takes consistent work but it's not very difficult.

[airfull]

So tell me if i'm wrong:

I should install PT3 full version on my laptop. Then i export the database from my desktop and move it to my laptop so i have my database up to date on both computers. Then i can play on my laptop (is all settings i made saved into the databse? like hud settings, and other thingss??).
Once i've finished to play on my laptop and return to home, i have to copy the history files from my laptop to my desktop and import it. If i want to play on my laptop once i get out of home (for example 2 weeks later and i've played on my desktop), i should copy the last hand history from desktop to laptop and import it import to my laptop database. etc...

If i'm wright , i think i'll use your advice :
"If I was doing this, I would have PC "A" move its processed files to folder "pa" and make sure that PC "B" has access to it.
Similarly have B move its processed files to another folder "pb".
I'd also then have another folder which they can both access where I will store all the HH files once they've been imported to both - call this "store".

When you finish playing on A and stop auto import so all the files have been moved to 'pa', have PT3 on B do a manual import of 'pa', then move the contents of 'pa' to 'store'.
After you play on B, the files are moved to 'pb', then run a manual import on A to import from 'pb' and then move the contents of 'pb' to 'store."

Another question


Should i make this procédure viewtopic.php?f=45&t=4638 if i play only on my desktop at home and only on my laptop when i'm not at home ?

[WhiteRider]

I should install PT3 full version on my laptop. Then i export the database from my desktop and move it to my laptop so i have my database up to date on both computers. Then i can play on my laptop (is all settings i made saved into the databse? like hud settings, and other thingss??).

Correct.
However, to copy your config across you will need to copy the PT3 backup files.

Once i've finished to play on my laptop and return to home, i have to copy the history files from my laptop to my desktop and import it. If i want to play on my laptop once i get out of home (for example 2 weeks later and i've played on my desktop), i should copy the last hand history from desktop to laptop and import it import to my laptop database. etc...

Correct.

Should i make this procédure viewtopic.php?f=45&t=4638 if i play only on my desktop at home and only on my laptop when i'm not at home ?

No - that is for when both computers are always networked.

[airfull]

ok thanks for your support.

I exported my database to my laptop and everythings seems to work fine but there is a small problem with the stats:

Here is the tournament summary stats on my desktop
http://moe.mabul.org/up/moe/2009/05/12/ ... 9.jpg.html

Here is the tournament summary stats on my laptop
http://moe.mabul.org/up/moe/2009/05/12/ ... p.jpg.html

Here is the cash game summary stats on my desktop
http://moe.mabul.org/up/moe/2009/05/12/ ... 0.jpg.html

Here is the cash game summary stats on my laptop
http://moe.mabul.org/up/moe/2009/05/12/ ... 7.jpg.html

As you see, there is some difference beetwin the stas on both computers (especially in cash game).
Do you think it will cause problems ? will this problem be fixed to the next import on my desktop (there's one ot two sessions more on my laptop)?

[WhiteRider]

The only real difference I can see is that it looks like a couple of sessions may have been merged, which were previously recorded as separate sessions?
The number of hands and winnings, etc seem the same?
If you can track down which session has different number of hands in the 2 DBs then we can try to find out why.

[feint06]

Is there a way to use the same database for two computers that aren't on the same router? I'm using a public wireless on my laptop (which is used only for mining) and would love it if I could have those hands automatically get imported on my desktop (rather than using a flash drive once a day)

[kraada]

You'd need to have the router forward port 5432 to your desktop at home, then edit the pg_hba.conf to allow the IP address of whatever public network you're on; PostgreSQL by default allows only those networks to connect that you'd like. I'd also strongly recommend continuing to use md5 encryption on the password; if you set it to trust then anybody from that network would be able to connect to your computer's postgres server without any authentication and that's a bit much in terms of a security risk for me, at least.

[airfull]

Am I concern by this ?

You'd need to have the router forward port 5432 to your desktop at home, then edit the pg_hba.conf to allow the IP address of whatever public network you're on; PostgreSQL by default allows only those networks to connect that you'd like. I'd also strongly recommend continuing to use md5 encryption on the password; if you set it to trust then anybody from that network would be able to connect to your computer's postgres server without any authentication and that's a bit much in terms of a security risk for me, at least.