current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 5 down vote favorite
3

getting this error message in ubuntu. in pg_hba.conf file, I tried using 'ident','peer','trust','md5' in different times.but no go. please help.

share|improve this question
1  
Same as this and this –  Frankline Jan 15 at 13:08
1  
Did you do any searching / research first? Show your config files. Explain what you tried. Show the commands and errors. –  Craig Ringer Jan 16 at 4:24

2 Answers 2

up vote 7 down vote accepted

in your pg_hba.conf

# IPv4 local connections:
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
host    all         all         127.0.0.1/32         trust

if it does not work then try with

host    all         all         your_ip/32         trust

then restart your data base it will work fine

share|improve this answer
up vote 1 down vote

If the username and password are correct then md5 is the correct value. Make sure you restart the database process or at least have it reload the configuration after modifying pg_hba.conf.

share|improve this answer
    
muchas gracias @fog. restarting postgresql server resolved my issue. –  sayan Jan 16 at 5:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.