remote IP changed, now PT2 can't connect to database

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

remote IP changed, now PT2 can't connect to database

Postby msbuss » Mon Jul 21, 2008 11:36 pm

I am running postgres natively on a mac, keeping the db on the mac while running PT2 in XP using Parallels. PT2 knows the db server is at 192.168.1.4, and all is well.

I just replaced my router, and the machine that was 192.168.1.4 on my network is now 192.168.1.2. Suddenly PT2 can't find the db, giving me the error: 101 - SQLSTATE = 08001, could not connect to server, is the server running on host "192.168.1.4" etc, etc.

No problem. I go to postgresql settings and change the server to 192.168.1.2.

BUT...every time I start up PT2, it STILL looks for the server at 192.168.1.4, giving me the aforementioned error. I open postgresql settings again, and it shows the server address has been changed to 192.168.1.2.

So why is PT2 looking in the wrong place, even though I told it the right place to look?
msbuss
 
Posts: 16
Joined: Thu Mar 13, 2008 1:09 am

Re: remote IP changed, now PT2 can't connect to database

Postby ptrack pat » Mon Jul 21, 2008 11:43 pm

You need to go to the File > Maintain Database Names window, click the Add button and in the last field select "Select existing PostgreSQL database" from the list and re-add a new pointer to this database.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: remote IP changed, now PT2 can't connect to database

Postby msbuss » Tue Jul 22, 2008 10:15 am

Should I remove the ones that are in the list already?
msbuss
 
Posts: 16
Joined: Thu Mar 13, 2008 1:09 am

Re: remote IP changed, now PT2 can't connect to database

Postby ptrack pat » Tue Jul 22, 2008 10:34 am

You don't have to but to avoid confusion it's probably a good idea.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: remote IP changed, now PT2 can't connect to database

Postby msbuss » Tue Jul 22, 2008 4:25 pm

Nailed it. Thanks.
msbuss
 
Posts: 16
Joined: Thu Mar 13, 2008 1:09 am


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests