Обсуждение: Problems with adding IP to pg_hba.conf
Hi all, I need to let a server access our postgreSQL database but I´m having problems with the configuration. I´m getting the error message below, psql: FATAL: no pg_hba.conf entry for host "10.24.17.22", user "k175", database "k175", SSL off I´ve added the section below to the pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 10.24.17.0/24 md5 Still resulting in the above error. Can somebody guide me to what is wrong? Thanks Christian -- View this message in context: http://postgresql.1045698.n5.nabble.com/Problems-with-adding-IP-to-pg-hba-conf-tp5768809.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 2013-08-28 2:00 PM, Chrishelring wrote: > Hi all, > > I need to let a server access our postgreSQL database but I´m having > problems with the configuration. I´m getting the error message below, > > psql: FATAL: no pg_hba.conf entry for host "10.24.17.22", user "k175", > database "k175", SSL off > > I´ve added the section below to the pg_hba.conf > > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > # IPv4 local connections: > host all all 10.24.17.0/24 md5 > > Still resulting in the above error. Can somebody guide me to what is wrong? > > Thanks > > Christian > > > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/Problems-with-adding-IP-to-pg-hba-conf-tp5768809.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > Are you sure you reloaded the config after making the above change? (happened to me couple times before, so worth a try :) Ziggy
On 08/28/2013 07:00 AM, Chrishelring wrote: > psql: FATAL: no pg_hba.conf entry for host "10.24.17.22", user "k175", > database "k175", SSL off Did you reload the configuration files after changing pg_hba.conf? If not, you need to use the init script, or pg_ctl and send a reload command. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-676-8870 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email