From: Oisin Glynn <me@oisinglynn.com>
To: Catalin Pitis <cpitis.pgsql@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Connecting to Postgres from other machines (outside localhost)
Date: Thu, 04 May 2006 14:00:57 -0400
Message-ID: <445A4159.2060707@oisinglynn.com> (raw)
In-Reply-To: <63c4c13c0605041052q4212965bua0a3a376ba8abf3f@mail.gmail.com>
References: <63c4c13c0605041052q4212965bua0a3a376ba8abf3f@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: me@oisinglynn.com, cpitis.pgsql@gmail.com
Subject: Re: Connecting to Postgres from other machines (outside localhost)
In-Reply-To: <445A4159.2060707@oisinglynn.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox