Re: reg db access from windows

["sandhya" <sandhyar@xxxxxxxxxxxxxx>]

If i am using local host......Should we not use IP addree of that .

like:

char ConnInfo[]={"dbname=pilot user=postgres password=megarac host=localhost port=5432"};

When iam giving host = 10.9.8.54(local ip where the DB is running)...The following error iam getting

Connection to database failed
FATAL:  no pg_hba.conf entry for host "10.0.0.205", user "postgres", database "pilot", SSL off
Press any key to continue

 

Please tell me why is it so?

 

-Sandhya

 

 

----- Original Message -----

From: sandhya

To: postgre

Cc: sandhya

Sent: Wednesday, January 04, 2006 6:17 PM

Subject: [ADMIN] reg db access from windows

Hi...

 When i am trying to connect to the database in the local windows system where database server is running as service

I am getting the following error message.

 

Connection to database failed
FATAL:  no pg_hba.conf entry for host "10.0.0.205", user "postgres", database "pilot", SSL off
Press any key to continue

 

The following is there in pg_hba.conf.sample file

 

@authcomment@

 

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

 

@remove-line-for-nolocal@# "local" is for Unix domain socket connections only
@remove-line-for-nolocal@local   all         all                               @authmethod@
# IPv4 local connections:
host    all         all         127.0.0.1/32          @authmethod@
# IPv6 local connections:
host    all         all         ::1/128               @authmethod@

 

Please tell me what i need to do.I used it in Linux and working fine.This is first time i am working in windows.

Please suggest me how to proceed.

 

Thank you...

 

-Sandhya