Обсуждение: Connecting to Postgres from other machines (outside localhost)
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
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
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.
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:# IPv4 local connections:
host all all 127.0.0.1/32 md5host 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/postgres8Where postgres8 is the name of the database.I still can't connect...Can you give me a hint?ThanksCatalin
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
Вложения
Ok, I found it, it was my mistake.
An IP entry should be have /32 or /128. I used different values. Now I got it (RTFM).
Regards,
Catalin
On 5/4/06, Oisin Glynn <me@oisinglynn.com> wrote:
Catalin Pitis wrote:
> I did all you said:
>
> I set pg_hba.conf:
>
> # IPv4 local connections:
> host all all 127.0.0.1/32
> <http://127.0.0.1/32> md5
> host all all 192.168.197.1/192
> <http://192.168.197.1/192> md5
> host all all 192.168.123.1/192
> < http://192.168.123.1/192> md5
> host all all 192.168.0.1/192
> <http://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
> <mailto: 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
> <http://127.0.0.1/32> md5
> host all all 192.168.10.1/24
> <http://192.168.10.1/24> md5
> # IPv6 local connections:
> #host all all ::1/128 md5
>
>
Did you stop and start Postgres Service?