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(dot)compgsql-gen(at)basebeans(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, March 21, 2002 7:10 PM
Subject: [GENERAL] pg_hba.conf error

> Subject: pg_hba.conf error
> From: "alt.cybercafes" <pmunis(at)hotmail(dot)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(at)postgresql(dot)org