pg_hba.conf

Started by quickinfo quickinfoover 15 years ago2 messagesgeneral
Jump to latest
#1quickinfo quickinfo
quickinfo123@gmail.com

Dear all,

I am using postgres. when I try to connect to the database it is showing me
following error. Please look into that and help me out.

an error occurred:

FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database
"template1", SSL off.

How do I proceed with this error. What are the things I need to change.

Thank you in advance

#2A. Kretschmer
andreas.kretschmer@schollglas.com
In reply to: quickinfo quickinfo (#1)
Re: pg_hba.conf

In response to quickinfo quickinfo :

Dear all,

I am using postgres. when I try to connect to the database it is showing me
following error. Please look into that and help me out.

an error occurred:

FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database
"template1", SSL off.

How do I proceed with this error. What are the things I need to change.

You have to read the doc about the hba-file first!
http://www.postgresql.org/docs/current/static/client-authentication.html

Usually you should not work as user postgres...

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99