Network connection to database fails

[grahamc]

I've read all of the threads that I can find on this issue, including the "How To" post. No luck so far. Looking for some help, if possible.

WinXP desktop PC is running PT3. No problems. Default PSQL installation. Desktop PC is connected to router.

WinXP laptop has PT3 installed. Did not install PSQL. I want to connect to the same database. Wireless connection to the same router.

Desktop IP is 192.168.0.102
Laptop IP is 192.168.0.103

On desktop, pg_hba.conf includes this:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
host all all 192.168.0.1/127 md5

postgresql.conf includes this:

listen_addresses = '*'

Task Manager shows that postgresql service is running.

I fire up PT3 on the laptop. Asks if I want to install PSQL. I say 'No'. I get the 'Configure PSQL Server' box.
Change localhost to 192.168.0.102. Leave database user and port as postgres and 5432 respectively. Enter dbpass in the password box.

Unable to connect to this database. Please check the configuration.

Bummer.

I am not running AV software.
I have added an exception for for 5432 (TCP) for computers on my subnet in Windows firewall. I even tried it with the firewall off.
I have uninstalled PostgreSQL and reinstalled it (8.3.7) according to the documentation on this forum.

Same problem.

Any thoughts? Hopefully I'm simply a dummy who's made on obvious mistake.

-Graham

[grahamc]

Yup, I'm a dummy. I altered the instructions, thinking that I needed to change the IP parameters since my IP was a high number, but I set it back to 0/24 and it looks like it works now.

Thanks for reading!

[kraada]

In case you're curious why 0/24 is used, see this wikipedia article.