no pg_hba.conf entry for host

From: "Surabhi Ahuja " <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: "pgsql-general(at)postgresql(dot)org" <'pgsql-general(at)postgresql(dot)org'>
Subject: no pg_hba.conf entry for host
Date: 2005-02-21 12:24:56
Message-ID: CE5C48E227F8ED4990FAC4332100ADC621B504@EVS.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i have written a program:

#include<stdlib.h>
#include<libpq-fe.h>
int main()
{
PGconn *myconnection = PQconnectdb("host = indra user = surabi password = test123 port = 5432 dbname=bpsimple");
if(PQstatus(myconnection) == CONNECTION_OK)
printf("Connection made\n");
else
printf("Connection failed : %s\n", PQerrorMessage(myconnection));
PQfinish(myconnection);
return 0;
}

from one host 3.70.201.172 , I try to connect to a remote host "indra", that is running postgreSQL server.

I ran the postmaster on "indra" like:
/usr/local/pgsql/bin/postmaster -h 3.70.201.172 -i -D ./data/&

However i get this error message
no pg_hba.conf entry for host "3.70.201.172", user "surabi", database "bpsimple"

Please tell what to do?

regards
surabhi


Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2005-02-21 12:35:28 Re: Ways to speed up dump&reload
Previous Message Magnus Hagander 2005-02-21 12:04:36 Re: Ways to speed up dump&reload