networking PT3 with postgreSQL on both computers

[kalensc]

postgresql.conf looks ok.

i cannot tell from your ipconfig if this is from the server or client?

what needs to go in pg_hba.conf is the ip of the client accessing the server, and you edit the server's pg_hba.conf.

so if i assume i AM looking at the client's ipconfig in your post, is goes something like this:

host all all 192.168.0.101/32 trust

to answer your other post, yes you can have the postgres db wherever you want it - moving populated db's is not for the faint hearted though - make sure you have double backups via 2 different methods just in case...


susan

OK, well I guess I got it backwards.

PC = client
laptop = server

IP of server = 192.168.0.101 (so, new PT3 database accesses this as the server)
IP of client = 192.168.0.105 (the correct IP for pg_hba)

So, now I've edited the laptop pg_hba to include "host all all 192.168.0.105/32 trust", and I've edited the PC pg_hba back to it's original contents.

And it creates a databse on the client, and I set it to active. But no data loads - I have nothing in this database according to the client.

What do I need to do now?

Edit: Does it matter if PT3 on the server (laptop) is v3.00 build 2, and client (desktop) is v3.00 beta 12? I'm trying to get the latest updates right now.

[scbrigad]

postgresql.conf looks ok.

i cannot tell from your ipconfig if this is from the server or client?

what needs to go in pg_hba.conf is the ip of the client accessing the server, and you edit the server's pg_hba.conf.

so if i assume i AM looking at the client's ipconfig in your post, is goes something like this:

host all all 192.168.0.101/32 trust

to answer your other post, yes you can have the postgres db wherever you want it - moving populated db's is not for the faint hearted though - make sure you have double backups via 2 different methods just in case...


susan

OK, well I guess I got it backwards.

PC = client
laptop = server

IP of server = 192.168.0.101 (so, new PT3 database accesses this as the server)
IP of client = 192.168.0.105 (the correct IP for pg_hba)

So, now I've edited the laptop pg_hba to include "host all all 192.168.0.105/32 trust", and I've edited the PC pg_hba back to it's original contents.

And it creates a databse on the client, and I set it to active. But no data loads - I have nothing in this database according to the client.

What do I need to do now?

Edit: Does it matter if PT3 on the server (laptop) is v3.00 build 2, and client (desktop) is v3.00 beta 12? I'm trying to get the latest updates right now.

Maybe you created a NEW database on your laptop/server from the desktop instead of linking to an existing database? After cliking "New" did you enter the laptop's IP and then click "browse databases" and get a list of the databases already existing on your laptop? If your setup is correct it will browse all the databases on your laptop....

[kalensc]

postgresql.conf looks ok.

i cannot tell from your ipconfig if this is from the server or client?

what needs to go in pg_hba.conf is the ip of the client accessing the server, and you edit the server's pg_hba.conf.

so if i assume i AM looking at the client's ipconfig in your post, is goes something like this:

host all all 192.168.0.101/32 trust

to answer your other post, yes you can have the postgres db wherever you want it - moving populated db's is not for the faint hearted though - make sure you have double backups via 2 different methods just in case...


susan

OK, well I guess I got it backwards.

PC = client
laptop = server

IP of server = 192.168.0.101 (so, new PT3 database accesses this as the server)
IP of client = 192.168.0.105 (the correct IP for pg_hba)

So, now I've edited the laptop pg_hba to include "host all all 192.168.0.105/32 trust", and I've edited the PC pg_hba back to it's original contents.

And it creates a databse on the client, and I set it to active. But no data loads - I have nothing in this database according to the client.

What do I need to do now?

Edit: Does it matter if PT3 on the server (laptop) is v3.00 build 2, and client (desktop) is v3.00 beta 12? I'm trying to get the latest updates right now.

Maybe you created a NEW database on your laptop/server from the desktop instead of linking to an existing database? After cliking "New" did you enter the laptop's IP and then click "browse databases" and get a list of the databases already existing on your laptop? If your setup is correct it will browse all the databases on your laptop....

Haha, I noticed that "browse databases" option the first time I was trying to set this up, and completely forgot about it on all subsequent attempts. I've got it to work now.

Thanks a ton for your help and patience!