From: Antonello De Santis <ua01020@flashnet.it>
Reply-To: ua01020@flashnet.it
Organization: Antani
To: pgsql-interfaces@postgresql.org
Subject: pg_hba.conf
Date: Sun, 28 Mar 1999 21:46:03 +0200
Content-Type: text/plain
MIME-Version: 1.0
Message-Id: <99032822051500.00581@zeman>
Content-Transfer-Encoding: 8bit

Hi again,

I need help to set up the config file pg_hba.conf..... The problem is that the
database only accepts connections coming from a local unix socket and not from
a valid tcp/ip address.
My pg_hba.conf file looks like this:

local        all					trust
host         all         192.168.1.0     255.255.255.0    trust

I have a local network made up of two machines whose addresses are 192.168.1.1
and 192.168.1.2, so I tell to accept every request coming from the local
network. If I comment out the first line, relative to unix socket, and restart
postgresql, when I try to access a database I get an error message "user
authentication failed". Why's that? I think I start the postmaster in the right
way, that is, specifying the -i option:

case "$1" in
  start)
	echo -n "Starting postgresql service: "
	su postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'
	sleep 1
	pid=`pidof postmaster`
	echo -n "postmaster [$pid]"
	touch /var/lock/subsys/postmaster
	echo
	;;

Thank you for your help.
Greetings,

  Antonello De Santis