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

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(dot)pgsql(at)gmail(dot)com> wrote:
>
> 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(at)oisinglynn(dot)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
> >
> >
>