Postgres Pro
Downloads
Home   >   mailing lists

reg db access from windows - Mailing list pgsql-admin

From sandhya
Subject reg db access from windows
Date
Msg-id 014401c6112c$f6ccfbe0$cd00000a@amiindiahjwbgh
Whole thread Raw
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Pandurangan R S
Date:
Subject: Re: psql: could not connect to server: Network is unreachable
Next
From: "sandhya"
Date:
Subject: Re: reg db access from windows