Problems with adding IP to pg_hba.conf

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general