Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connecting to PostgreSQL Server

Connecting to PostgreSQL Server

From
Lukasz
Date:
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

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

Re: Connecting to PostgreSQL Server

From
viniciusasousa@yahoo.com.br
Date:
I am brazilian and have write dificility ,but code pg_hba is:
host     all     all     192.168.254.105/32  md5

and after reload configuration.


Belê!

Re: Connecting to PostgreSQL Server

From
Shane Ambler
Date:
On 21/9/2006 18:36, "Lukasz" <fatmouse@REMOVEITo2.pl> 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@007Marketing.com

Get Sheeky @ http://Sheeky.Biz