Re: [GENERAL] Problems with adding IP to pg_hba.conf
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 stho...@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
Re: [GENERAL] 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 DATABASEUSERCIDR-ADDRESS METHOD # IPv4 local connections: hostall 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
[GENERAL] 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 DATABASEUSERCIDR-ADDRESS METHOD # IPv4 local connections: hostall 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general