X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0F6059DC9A0 for ; Wed, 4 Jan 2006 08:41:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07616-02 for ; Wed, 4 Jan 2006 08:41:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id D77909DC89C for ; Wed, 4 Jan 2006 08:41:43 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k04Cb8Qw006018 for ; Wed, 4 Jan 2006 18:07:09 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 9A18D33266F; Wed, 4 Jan 2006 18:04:42 +0530 (IST) Message-ID: <014401c6112c$f6ccfbe0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: reg db access from windows Date: Wed, 4 Jan 2006 18:17:03 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0141_01C6115B.1055EA80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:63.39459 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.05 required=5 tests=[AWL=0.048, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.05 X-Spam-Level: X-Archive-Number: 200601/43 X-Sequence-Number: 20131 This is a multi-part message in MIME format. ------=_NextPart_000_0141_01C6115B.1055EA80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_0141_01C6115B.1055EA80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi...
 When i am trying to connect to = the database=20 in the local windows system where database server is running as=20 service
I am getting the following = error=20 message.
 
Connection to database=20 failed
FATAL:  no pg_hba.conf entry for host = "10.0.0.205",=20 user "postgres", database "pilot", SSL off
Press any key to=20 continue
 
The following is there in pg_hba.conf.sample file
 
@authcomment@
 
# TYPE  DATABASE    = USER       =20 CIDR-ADDRESS         =20 METHOD
 
@remove-line-for-nolocal@# "local" is = for Unix=20 domain socket connections = only
@remove-line-for-nolocal@local  =20 all        =20 all           &nbs= p;            = ;      =20 @authmethod@
# IPv4 local connections:
host   =20 all        =20 all        =20 127.0.0.1/32         =20 @authmethod@
# IPv6 local connections:
host   =20 all        =20 all        =20 ::1/128           =    =20 @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
------=_NextPart_000_0141_01C6115B.1055EA80--