Re: Connecting to Postgres from other machines (outside localhost)

I did all you said:

 

I set pg_hba.conf:

 

# IPv4 local connections:
host    all         all         127.0.0.1/32           md5

host    all         all         192.168.197.1/192          md5
host    all         all         192.168.123.1/192          md5
host    all         all         192.168.0.1/192          md5
 

 

I set postgres.conf:

 

listen_addresses = '*' # what IP interface(s) to listen on;
    # defaults to localhost, '*' = any
port = 5433
max_connections = 100
 

I'm using jdbc with the following URL:

 

jdbc:postgresql://192.168.197.1:5433/postgres8

 

Where postgres8 is the name of the database.

 

I still can't connect...

 

Can you give me a hint?

 

Thanks

Catalin

 

On 5/4/06, Oisin Glynn <me@oisinglynn.com> wrote:

Catalin Pitis wrote:
> Hello
>
> I installed PostgreSQL 8.0 on Windows and I can connect from localhost
> only. How can I configure the server to allow connection from other
> machines?
>
> Thank you
> Catalin
Under
Start-> Programs->PostgreSQLXX->Configuration files
postgresql.conf
pg_hba.conf

Are the 2 files I modified.  Please be aware my settings are for a dev
box and are WIDE OPEN AS SHOWN HERE this might allow alot more people
connect than you want.

postgresql.conf
# - Connection Settings -

listen_addresses = '*'        # what IP address(es) to listen on;
                   # comma-separated list of addresses;
                   # defaults to 'localhost', '*' = all
port = 5432
max_connections = 100

pg_hba.conf
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         192.168.10.1/24          md5
# IPv6 local connections:
#host    all         all         ::1/128               md5