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
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 abcdethe 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
detailswhat'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
Show quoted text
appreciated.
thanks
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org