On 21/9/2006 18:36, "Lukasz" <fatmouse@xxxxxxxxxxxxx> wrote: > Hello, > > I installed a postgresql server on one of the machine in my network with > an example IP 192.168.254.102. I have no problem to connect to the > server from this machine, but when I want to have access to pgsql server > from other pc with an example IP 192.168.254.105 it says that I have no > access to database and it suggests adding this line to pg_hba.conf file: > > host all all 192.168.0.0/24 md5 That is a generic message and doesn't match your network config. Change the 192.168.0.0/24 to 192.168.254.0/24 (assuming your netmask is 255.255.255.0) to allow any computer on your local network to connect or 192.168.254.105/32 to allow the one example computer to connect. > Even when I add it, the error is the same. > > My pga_hba file looks like 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.0/24 md5 > > The beginning of the postgresql.conf: > > listen_addresses = '*' # what IP address(es) to listen on; > # comma-separated list of addresses; > # defaults to 'localhost', '*' = all > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Shane Ambler Postgres@xxxxxxxxxxxxxxxx Get Sheeky @ http://Sheeky.Biz
