Re: I get a error msg when i try to connect to the DB
От | Brad Nicholson |
---|---|
Тема | Re: I get a error msg when i try to connect to the DB |
Дата | |
Msg-id | 1187280347.29355.113.camel@bnicholson-desktop обсуждение исходный текст |
Ответ на | I get a error msg when i try to connect to the DB ("Rajaram J" <rajarj@hotmail.com>) |
Ответы |
Re: I get a error msg when i try to connect to the DB
|
Список | pgsql-general |
On Thu, 2007-08-16 at 21:16 +0530, Rajaram J wrote: > Hi > > I have installed PostGRESql 7.4.17 and when i try to connect to the db > i get the msg > > psql: FATAL: no pg_hba.conf entry for host "???", user "sfmdb", > database "LOGDB", SSL off > You are allowing local, non TCP/IP connctions, and connections through the loop back, but you are not allowing remote conncetions. You need an entry of some form that is host all all ??? 255.255.255.255 trust btw, trust is usually bad, you should use some form of authentication. > My pg_hba.conf entry is as below > > > > # TYPE DATABASE USER IP-ADDRESS IP-MASK > METHOD > > # Disable default configuration > > local all all > trust > # IPv4-style local connections: > host all all 127.0.0.1 255.255.255.255 > trust > # IPv6-style local connections: > host all all ::1 > ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust > > > can you please guide me on what the problem might be. > > Regards > > Rajaram > > -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
В списке pgsql-general по дате отправления: