Re: [GENERAL] Problems with adding IP to pg_hba.conf

2013-08-28 Thread Shaun Thomas

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

2013-08-28 Thread Ziggy Skalski

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

2013-08-28 Thread Chrishelring
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