Re: pg_hba.conf error

Depends on how important your security is.

the pg_hba.conf entry is in the following format for the network.


host  DBNAME  IP_ADDRESS  ADDRESS_MASK  AUTHTYPE  [AUTH_ARGUMENT]

For local connection from the server itself (safe to keep as is)


local        all                                           trust
host         all         127.0.0.1     255.255.255.255     trust

From the network

host         all       192.168.1.4       255.255.255.255   trust
or more secure
host         all       192.168.1.4       255.255.255.255   password

or your whole network
host         all       192.168.1.0       255.255.255.0   trust

http://www.pgexplorer.com
GUI PostgreSQL Client


----- Original Message -----
From: "pgsql-gen Newsgroup" <@Basebeans.compgsql-gen@basebeans.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, March 21, 2002 7:10 PM
Subject: [GENERAL] pg_hba.conf error


> Subject: pg_hba.conf error
> From: "alt.cybercafes" <pmunis@hotmail.com>
>  ===
> I am trying to connect to postgresql remotely using pgAdmin2 (within my
> private network) . my pg_hba.conf is as follows.
> local      all         192.168.1.4                      ident   abcde
>  host         all       192.168.1.4       255.255.255.255   ident   abcde
>
> the serverlog is as follows
> =======================================
> parse_hba: invalid syntax in pg_hba.conf file at line 244, token
> "192.168.1.4"
> FATAL 1:  Missing or erroneous pg_hba.conf file, see postmaster log for
> details
> parse_hba: invalid syntax in pg_hba.conf file at line 244, token
> "192.168.1.4"
> FATAL 1:  Missing or erroneous pg_hba.conf file, see postmaster log for
> details
> parse_hba: invalid syntax in pg_hba.conf file at line 244, token
> "192.168.1.4"
> FATAL 1:  Missing or erroneous pg_hba.conf file, see postmaster log for
> details
>
> what's the proper way to setup pg_hba.conf to allow remote connection eith
> from clients such as pgadmin2 or java (jdbc)? A sample file will be
greatly
> appreciated.
>
> thanks
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org