pg_hba.conf

Поиск
Список
Период
Сортировка
От Antonello De Santis
Тема pg_hba.conf
Дата
Msg-id 99032822051500.00581@zeman
обсуждение исходный текст
Ответы Re: [INTERFACES] pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tomaz Borstnar
Дата:
Сообщение: latest PsqlODBC on NT4SP4 - didn't find ODBC Manager installed??
Следующее
От: Bob VonMoss
Дата:
Сообщение: Re: [INTERFACES] pg_hba.conf