On 5/31/07, Bhavana.Rakesh <[EMAIL PROTECTED]> wrote:
Ok, I confirmed that I'm editing the right pg_hba.conf file. I made sure that there are no other postmasters running. I made sure that there is a user called 'brakesh'. I restart the postmaster everytime I make any changes to pg_hba.conf file. But still same results! [EMAIL PROTECTED] ~/db_connect]$ psql -U brakesh -h 127.0.0.1 -d testing123 psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "brakesh", database "testing123", SSL off [EMAIL PROTECTED] ~/db_connect]$ psql -p 5000 testing123 Welcome to psql 7.4.17, the PostgreSQL interactive terminal.
Why are you specifying the port number when you don't include the host? What happens if you do include the port: psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123 -- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly