Having PT3 on two computers

[kraada]

That only matters if you want to connect to your database from outside of your local network. If you're still behind your local network (via your home wireless, or some such), you don't need to worry about that.

Basically the only way there can be a security issue with PostgreSQL is if you explicitly set it up to be insecure, which is what I was warning against.

[airfull]

That only matters if you want to connect to your database from outside of your local network.

Yes it's the case, i would like to play on my laptop (and use PT3) when i'm outside of my local network by using my parent's or a friend's router. Is there a post which explain the procedure to configure it to let me acces my database and use md5 encryption on the password ?

Basically the only way there can be a security issue with PostgreSQL is if you explicitly set it up to be insecure, which is what I was warning against.

By default, it's set up to be secure ? (I mean i i've followed all the instruction when i installed it).

[kraada]

Yes, by default it is set up to be secure.

There are four steps to make sure your database is accessible from outside your internal network.

(1) Edit postgresql.conf (Start --> Programs --> PostgreSQL --> Edit postgresql.conf), set listen_addresses = '*'.

(2) Edit pg_hba.conf (Start --> Programs --> PostgreSQL --> Edit pg_hba.conf) and add a line at the bottom to allow the IP addresses you want in. If you want to allow all IPs to connect, 0.0.0.0/0 will allow everyone in. Make sure it says md5 on the line, not trust. Basically copy the line that is there by default for 127.0.0.1 (if you edited that to be trust, in the new line make sure it's md5). If you know you're going to be in a specific place, you can restrict this more as you please; it uses CIDR notation.)

(3) Restart PostgreSQL (Start --> Programs --> PostgreSQL --> Stop Services, followed by Start --> Programs --> PostgreSQL --> Start Services).

(4) Set your router to forward port 5432 to your PostgreSQL server.

Then you will be able to connect to your PostgreSQL server at your IP address from anywhere else on the internet. (You will need to know your external IP for your computer, of course.)

[airfull]

Thank you for answer. Should i follow this procédure on both computers or only on my laptop ?

(2) Edit pg_hba.conf (Start --> Programs --> PostgreSQL --> Edit pg_hba.conf) and add a line at the bottom to allow the IP addresses you want in. If you want to allow all IPs to connect, 0.0.0.0/0 will allow everyone in. Make sure it says md5 on the line, not trust. Basically copy the line that is there by default for 127.0.0.1 (if you edited that to be trust, in the new line make sure it's md5).

Ok , so when it's written "md5" it's secured. But there's something i didn't understand. if i allow any IP adress, could anyone connect to my database ?

(4) Set your router to forward port 5432 to your PostgreSQL server.

HOw can i make this ?


"(You will need to know your external IP for your computer, of course.)" Do you mean there's something else to set tup when i connetc to my database out of my local network ?
When you say "external IP of my computer" you mean my network IP adress ? Where can i Find it ?

[kraada]

Anyone could attempt to connect, yes. That's one reason why PostgreSQL doesn't allow this sort of access by default.

The other thing to do is to allow specific IP ranges to connect (if you're always in a certain place, you can set those IPs to connect), but then you need to know where you're going to be connecting from.

With regards to your router, it depends on what sort of router you have.

To find your external IP address, go here and it will tell you.

[airfull]

Hi, up to thid post!

I've tried to play at my parents home this week and everything worked fine but i was wondering about something! I didn't have to make this to be able to use my database:

Yes, by default it is set up to be secure.

There are four steps to make sure your database is accessible from outside your internal network.

(1) Edit postgresql.conf (Start --> Programs --> PostgreSQL --> Edit postgresql.conf), set listen_addresses = '*'.

(2) Edit pg_hba.conf (Start --> Programs --> PostgreSQL --> Edit pg_hba.conf) and add a line at the bottom to allow the IP addresses you want in. If you want to allow all IPs to connect, 0.0.0.0/0 will allow everyone in. Make sure it says md5 on the line, not trust. Basically copy the line that is there by default for 127.0.0.1 (if you edited that to be trust, in the new line make sure it's md5). If you know you're going to be in a specific place, you can restrict this more as you please; it uses CIDR notation.)

(3) Restart PostgreSQL (Start --> Programs --> PostgreSQL --> Stop Services, followed by Start --> Programs --> PostgreSQL --> Start Services).

(4) Set your router to forward port 5432 to your PostgreSQL server.

Then you will be able to connect to your PostgreSQL server at your IP address from anywhere else on the internet. (You will need to know your external IP for your computer, of course.)

Does it mean that my database is not secure ??

[WhiteRider]

Are you saying that you connected to the database on your home computer over the internet?
As kraada said, by default postgres is set up to prevent that - did you make any changes?

[airfull]

Usually i play at my home with my desktop computer but this week i was at my parents home (100km from my house) and i played all the week with my laptop. I exported my database to my laptop first then play all the week without making the changes as he says, et since i return home i've imported the hand history of my laptop to my desktop so the databases are up to date!

Is there any problem here ? Should i check something in settings or toher ?

[WhiteRider]

If you made your own copy of the database and took it with you then you weren't connecting over the internet - you were just using it on the local computer again so nothing is different.

The changes only apply if you want to connect to a database on a different computer over the internet.

[airfull]

The changes only apply if you want to connect to a database on a different computer over the internet.

You mean that it only apply when i try to connect to the database on my desktop by using my laptop ?

This is what i exactly do:

WHITE RIDER SAYS " 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."