pg_hba.conf
От | Antonello De Santis |
---|---|
Тема | pg_hba.conf |
Дата | |
Msg-id | 99032822051500.00581@zeman обсуждение исходный текст |
Ответы |
Re: [INTERFACES] pg_hba.conf
|
Список | 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
В списке pgsql-interfaces по дате отправления: