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 DCEC89DCA22 for ; Wed, 4 Jan 2006 08:59:04 -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 09263-05 for ; Wed, 4 Jan 2006 08:59:07 -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 823A19DC9C9 for ; Wed, 4 Jan 2006 08:59:01 -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 k04CsTBv008918 for ; Wed, 4 Jan 2006 18:24:29 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 06268332666; Wed, 4 Jan 2006 18:24:22 +0530 (IST) Message-ID: <017901c6112f$b5dbe4e0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" References: <014401c6112c$f6ccfbe0$cd00000a@amiindiahjwbgh> Subject: Re: reg db access from windows Date: Wed, 4 Jan 2006 18:36:43 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0176_01C6115D.CF61C640" 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:99.90000 C:21 M:2 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.053 required=5 tests=[AWL=0.051, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.053 X-Spam-Level: X-Archive-Number: 200601/44 X-Sequence-Number: 20132 This is a multi-part message in MIME format. ------=_NextPart_000_0176_01C6115D.CF61C640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If i am using local host......Should we not use IP addree of that . like: char ConnInfo[]=3D{"dbname=3Dpilot user=3Dpostgres password=3Dmegarac = host=3Dlocalhost port=3D5432"}; When iam giving host =3D 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 -----=20 From: sandhya=20 To: postgre=20 Cc: sandhya=20 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 ------=_NextPart_000_0176_01C6115D.CF61C640 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
If i am using local host......Should we = not use IP=20 addree of that .
like:

char ConnInfo[]=3D{"dbname=3Dpilot = user=3Dpostgres=20 password=3Dmegarac host=3Dlocalhost port=3D5432"};

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

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
 
Please tell me why is it so?
 
-Sandhya
 
 
----- Original Message -----
From:=20 sandhya
To: postgre
Cc: sandhya
Sent: Wednesday, January 04, = 2006 6:17=20 PM
Subject: [ADMIN] reg db access = from=20 windows

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=20 "10.0.0.205", 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   =20 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=20 fine.This is first time i am working in windows.
Please suggest me how to proceed.
 
Thank you...
 
-Sandhya
------=_NextPart_000_0176_01C6115D.CF61C640--