From: | Antonello De Santis <ua01020(at)flashnet(dot)it> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | pg_hba.conf |
Date: | 1999-03-28 19:46:03 |
Message-ID: | 99032822051500.00581@zeman |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tomaz Borstnar | 1999-03-28 19:47:00 | latest PsqlODBC on NT4SP4 - didn't find ODBC Manager installed?? |
Previous Message | Herouth Maoz | 1999-03-28 16:37:28 | Re: [INTERFACES] Questions about pq library and ecpg |