From: | Oisin Glynn <me(at)oisinglynn(dot)com> |
---|---|
To: | Catalin Pitis <cpitis(dot)pgsql(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Connecting to Postgres from other machines (outside localhost) |
Date: | 2006-05-04 18:00:57 |
Message-ID: | 445A4159.2060707@oisinglynn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ash Grove | 2006-05-04 18:10:56 | is an explicit lock necessary? |
Previous Message | Ben K. | 2006-05-04 17:55:56 | Re: [SQL] audit table containing Select statements submitted |