From: | "sandhya" <sandhyar(at)amiindia(dot)co(dot)in> |
---|---|
To: | "postgre" <pgsql-admin(at)postgresql(dot)org> |
Cc: | "sandhya" <sandhyar(at)amiindia(dot)co(dot)in> |
Subject: | Re: reg db access from windows |
Date: | 2006-01-04 13:06:43 |
Message-ID: | 017901c6112f$b5dbe4e0$cd00000a@amiindiahjwbgh |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)# "local" is for Unix domain socket connections only
@remove-line-for-nolocal(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-01-04 15:25:20 | Re: postmaster hangs |
Previous Message | sandhya | 2006-01-04 12:47:03 | reg db access from windows |