One database two computers

[DK115]

FYI

An important issue for me: Using on database within your home network and still put data in that database from two computers: is it possible with PT3!
Answer: Yes; I managed to do that.

Q for support: Can you use your the same license PT3 use on different computers (say 2 or 3) for your own use?



If you need to know how to configure ... ask.

[Josh]

The PT3 license will be similar to the current PT and PA Hud licenses. You'll be allowed to use PT3 on any two computers that you own.

[DK115]

Great!

Looking forward to the test HUD integration. With PT2/HUD was this two PC/one DB a hell of a job ...

[MMark516]

ok, since i have pt3 on 2 computers, how do i tell it that theres a database on one? so the other can just read it...or whatever, lol

[APerfect10]

When you add the database into the other computer, you will need to enter the IP address for the other computer, in the host field.

Best regards,

Derek

[DK115]

Situation

Compter 1: PT3 & Postgres Database; make sure that Computer 1 has a static IP adress.
Computer 2 (laptop?) only PT3

Step one:

You need to say to postgres that users from other computers can log in:

On Compter 1 add a line in pg_hba.conf file
like this

[i0g0]host all all 192.168.2.3 255.255.255.255 [/i0g0] trust
{where 192.168.2.3 is the ip adress of the laptop}.

If your using DHCP and you do not know the exact IP of the laptop the line will look like this

[i0g0]host all all 192.168.2.0 255.255.255.[/i0g0]0 trust
{where 192.168.2.0 is your network ...}

Step 2:

Then change the line in the postgressql.conf
[i0g0]listen_addresses = 'localhost' into listen_addresses = '*' [/i0g0]

Go to services on computer 1 and restart the PostgresSQL service

Step 3:

Go to the firewall confuration on computer 1 and make an execption for port 5432 (if it is not there) for the internal network.

Step 4:
Then start on computer 2 PT3 and give in the IP adress of Computer one where localhost is displayed; the DB on Computer 1 should be found ...

[JThomsen]

I assume it is still possible to import hands while playing on computer 2 (the one without postgresql)?
How will this affect CPU and HDD usage?

[APerfect10]

[quote="JThomsen"id9]I assume it is still possible to import hands while playing on computer 2 (the one without postgresql)?
How will this affect CPU and HDD usage?[/quoteid9]

It will lower both cpu and HDD usage on the non-PostgreSQL machine and increase it on the PostgreSQL machine. It is a good way to spread the load across two separate computers.

-Derek

[craftart2003]

I just wanted to say thank you for the information in this post. Very ingenious and helpful! Great Job!

[bozlax]

Here's an issue I'm seeing: I've got a Linux workstation running Postgres and hosting my PT database; I'm still on PT2, running it under wine on the Linux box, and WinXP on the laptop; if PT is running on the Linux box when I fire it up on the laptop, the copy on the laptop just hangs (hourglass cursor) and the only way to release it is through Task Manager. If I start it on the laptop first, then on the Linux box, no issue.

Any ideas? It's not a huge deal, I just sometimes have to walk ALL THE WAY ACROSS THE HOUSE to shut down PT on the workstation when I'm going to play on the laptop.