pg_hba.conf error

Started by pgsql-gen Newsgroupabout 24 years ago2 messagesgeneral
Jump to latest
#1pgsql-gen Newsgroup
pgsql-gen@basebeans.com

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

#2PG Explorer
pgmail@pgexplorer.com
In reply to: pgsql-gen Newsgroup (#1)
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

Show quoted text

appreciated.

thanks

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org