After I've changed the pg_hba.conf, I got the following error when connecting (from log file)
2006-05-04 21:57:26 LOG: invalid entry in file "C:/Program Files/PostgreSQL/8.0/data/pg_hba.conf" at line 68, token "
192.168.0.1/192"
2006-05-04 21:57:26 FATAL: missing or erroneous pg_hba.conf file
2006-05-04 21:57:26 HINT: See server log for details.
The pg_hba.conf file is attached...
Catalin
On 5/4/06, Catalin Pitis <cpitis.pgsql@gmail.com> wrote:I did all you said:
I set pg_hba.conf:
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
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