Re: jdbc pg_hba.conf error
От | gonzales@linuxlouis.net |
---|---|
Тема | Re: jdbc pg_hba.conf error |
Дата | |
Msg-id | Pine.LNX.4.64.0705301309490.28271@mx1.linuxlouis.net обсуждение исходный текст |
Ответ на | Re: jdbc pg_hba.conf error (Oliver Elphick <olly@lfix.co.uk>) |
Ответы |
Re: jdbc pg_hba.conf error
("Bhavana.Rakesh" <Bhavana.Rakesh@noaa.gov>)
|
Список | pgsql-general |
As super-user (postgres) you have to create the user in Postgres, then Grant access. In other words, if the pg_hba.conf file specifies a user who does not exist, "user brakesh does not exist" will cause a failure to connect as well. Every connection to a database, has to have a user associated with the session. So the fact that he has connected to at least one database, means he's gotten far enough to connect and create the proper ID/Authentication. Actually, I wonder if 'after' he's changed the pg_hba.conf file if he's been restarting the postgres process? Which is 'session' associated. Everytime you change the pg_hba.conf file, you have to restart postgres, don't you? On Wed, 30 May 2007, Oliver Elphick wrote: > On Wed, 2007-05-30 at 13:00 -0400, gonzales@linuxlouis.net wrote: >> Did you grant access to your user? > > If you mean grant access by an SQL GRANT, he hasn't got far enough to > check that. The error specifically says "no pg_hba.conf entry". As far > as I can see, his pg_hba.conf is OK. > >> >> On Wed, 30 May 2007, Oliver Elphick wrote: >> >>> On Wed, 2007-05-30 at 18:35 +0200, Martijn van Oosterhout wrote: >>>> On Wed, May 30, 2007 at 12:30:38PM -0400, Bhavana.Rakesh wrote: >>>>> Oliver, >>>>> >>>>> When I do a : >>>>> psql -p 5000 testing123 >>>>> I can make a connection. However, when I do a >>>>> >>>>> psql -U brakesh -h 127.0.0.1 -d testing123 >>>>> >>>>> I get the followign error: >>>>> >>>>> psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "brakesh", >>>>> database "testing123", SSL off >>>> >>>> Ofcourse, the first connection is a local connection, which you >>>> obviously have configured. The latter connects to localhost, which you >>>> havn't configured. >>> >>> His original message (which I snipped) said he had: >>> >>> # IPv4-style local connections: >>> host all all 127.0.0.1 255.255.255.255 trust >>> host testing123 brakesh 127.0.0.1 255.255.255.255 trust >>> >>> So it seems to me he did have it configured. >>> >>> In fact the first host line should be used and the second one for user >>> brakesh is redundant, since it comes later in the file. The only thing >>> I can see is that it might be related to SSL. >>> >>> >>> >> > -- Louis Gonzales louis.gonzales@linuxlouis.net http://www.linuxlouis.net
В списке pgsql-general по дате отправления: