Connection to a PG 8.0 Beta 1 win32 server
Hello !
I've installed the Beta 1 on Win XP Pro, it seem working correctly.
I load a database from Linux 7.4.3 with pgdumpall, it works too.
But I can't connect from other PC over the LAN (I modified pg_hba.conf for the hosts).
If I write in postgresql.conf :
tcpip_socket = true
port = 5432
I can't connect from the LAN, NEITHER from the local machine ?!
Where I've made a mistake ?
Luc
Secr�tariat wrote:
Hello !
I've installed the Beta 1 on Win XP Pro, it seem working correctly.
I load a database from Linux 7.4.3 with pgdumpall, it works too.
But I can't connect from other PC over the LAN (I modified pg_hba.conf
for the hosts).
If I write in postgresql.conf :
tcpip_socket = true
port = 5432
I can't connect from the LAN, NEITHER from the local machine ?!
Where I've made a mistake ?
Show us your pg_hba.conf, what is the exact error ?
Regards
Gaetano Mendola
Hello !
I've installed the Beta 1 on Win XP Pro, it seem working correctly.
I load a database from Linux 7.4.3 with pgdumpall, it works too.
But I can't connect from other PC over the LAN (I modified pg_hba.conf
for the hosts).
If I write in postgresql.conf :
tcpip_socket = true
port = 5432
I can't connect from the LAN, NEITHER from the local machine ?!
Where I've made a mistake ?Show us your pg_hba.conf, what is the exact error ?
Beta 1 Win32 server at 192.168.0.10,
W2k client at 192.168.0.11.
My pg_hba.conf :
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all md5
# IPv4-style local connections
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.0.0 255.255.255.255 md5
# IPv6-style local connections:
#host all all ::1/128 md5
Import Notes
Resolved by subject fallback
Hello !
I've installed the Beta 1 on Win XP Pro, it seem
working correctly.
I load a database from Linux 7.4.3 with pgdumpall, it works too.
But I can't connect from other PC over the LAN (I modified
pg_hba.conf for the hosts).
If I write in postgresql.conf :
tcpip_socket = true
port = 5432
I can't connect from the LAN, NEITHER from the local machine ?!
Where I've made a mistake ?Show us your pg_hba.conf, what is the exact error ?
Beta 1 Win32 server at 192.168.0.10,
W2k client at 192.168.0.11.
My pg_hba.conf :
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all
md5 # IPv4-style local connections
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.0.0 255.255.255.255 md5
That should be:
host all all 192.168.0.0 255.255.255.0 md5
if you want the whole subnet. Or if you want just your W2k client:
host all all 192.168.0.11 255.255.255.255 md5
//Magnus
Import Notes
Resolved by subject fallback
On 24/08/2004 08:23 Secr�tariat wrote:
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.0.0 255.255.255.255 md5
I think that line should be
host all all 192.168.0.0 255.255.255.0 md5
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+Secr�tariat wrote:
Hello !
I've installed the Beta 1 on Win XP Pro, it seem working correctly.
I load a database from Linux 7.4.3 with pgdumpall, it works too.
But I can't connect from other PC over the LAN (I modified pg_hba.conf
for the hosts).
If I write in postgresql.conf :
tcpip_socket = true
port = 5432
I can't connect from the LAN, NEITHER from the local machine ?!
Where I've made a mistake ?Show us your pg_hba.conf, what is the exact error ?
Beta 1 Win32 server at 192.168.0.10,
W2k client at 192.168.0.11.
My pg_hba.conf :
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all md5
# IPv4-style local connections
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.0.0 255.255.255.255 md5
# IPv6-style local connections:
#host all all ::1/128 md5
If you want allow all the network 192.168.0.0 then
your netmask have to be: 255.255.0.0
Regards
Gaetano Mendola