From sandhyar@amiindia.co.in Wed Jan 4 12:41:48 2006 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-- From sandhyar@amiindia.co.in Wed Jan 4 12:59:04 2006 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-- From sandhyar@amiindia.co.in Fri Jan 6 04:55:42 2006 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 1EE3B9DCB64 for ; Fri, 6 Jan 2006 00:55:42 -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 97334-01 for ; Fri, 6 Jan 2006 00:55:40 -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 F1B329DCB4E for ; Fri, 6 Jan 2006 00:55:36 -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 k064otfV018369; Fri, 6 Jan 2006 10:20:56 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 06BAD33266B; Fri, 6 Jan 2006 10:19:30 +0530 (IST) Message-ID: <007001c6127e$50a7eec0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Patrick Meylemans" Cc: "postgre" , "sandhya" References: <014401c6112c$f6ccfbe0$cd00000a@amiindiahjwbgh> <6.0.1.1.0.20060104135221.019c45f0@server04.site04.wtcm.be> <01a801c61130$ef080360$cd00000a@amiindiahjwbgh> <6.0.1.1.0.20060104145608.019e2ca8@server04.site04.wtcm.be> <002501c611b3$d2e68a20$cd00000a@amiindiahjwbgh> <6.0.1.1.0.20060105195734.019d1d10@server04.site04.wtcm.be> Subject: Re: reg db access from windows Date: Fri, 6 Jan 2006 10:31:55 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006D_01C612AC.6A278E90" 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:3 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.055 required=5 tests=[AWL=0.053, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.055 X-Spam-Level: X-Archive-Number: 200601/76 X-Sequence-Number: 20164 This is a multi-part message in MIME format. ------=_NextPart_000_006D_01C612AC.6A278E90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear patrick........... Thank you for your help. When i tried it i am getting the following message. postmaster signaled why is it so?pls explain me .... What i need to do for this. While connecting to the database if i am giving it as local host it is = considering and when i tried to give IP of that M/C it is giving error. I have added the line what u said. @authcomment@=20 # TYPE DATABASE USER CIDR-ADDRESS METHOD=20 @remove-line-for-nolocal@# "local" is for Unix domain socket connections = only=20 @remove-line-for-nolocal@local all all = @authmethod@=20 # IPv4 local connections:=20 host all all 127.0.0.1/32 @authmethod@ host pilot postgres 10.0.0.205/32 md5 # IPv6 local connections:=20 host all all ::1/128 @authmethod@=20 Please tell me..... -Sandhya ----- Original Message -----=20 From: Patrick Meylemans=20 To: sandhya=20 Sent: Friday, January 06, 2006 12:33 AM Subject: Re: [ADMIN] reg db access from windows Hi, Best is to log in as te user who owns the database (standard this = should be postgres I assume). Then you open a "dos box" -> start run cmd Then you type the following command c:\Program Files\PostgreSQL\8.1\bin\pg_ctl reload -D = c:\your_path_to_the_database A standard install is placing the databases at the following location = : c:\Program Files\Postgresql\8.1\data So the command will be c:\Program Files\Postgresql\8.1\bin\pg_ctl reload -D c:/Program = Files/Postgresql/8.1/data Kind regards Patrick At 05:52 5/01/2006, you wrote: I am using windows.U have mentioned about pg_ctl reload. In windows where i should give this command. Is it in the below path mentioned...? postgresql-8.0.0\src\bin\pg_ctl Please tell me. =20 -Sandhya ---- Original Message -----=20 From: Patrick Meylemans=20 To: sandhya=20 Sent: Wednesday, January 04, 2006 7:27 PM Subject: Re: [ADMIN] reg db access from windows Hi ... Best to do is to fire the command from the user who installed the = database. In the startup files you can see the location of your data = directory .. Is it a win box or a Linux machine ? CU Patrick At 14:15 4/01/2006, you wrote: hi.... Do not forget pg_ctl reload -D /your_path_to_the_data where i need to give this pg_ctl reload=20 whether in the below path or where? postgresql-8.0.0\src\bin\pg_ctl thanks, Sandhya =20 ----- Original Message -----=20 From: Patrick Meylemans=20 To: sandhya=20 Sent: Wednesday, January 04, 2006 6:24 PM=20 Subject: Re: [ADMIN] reg db access from windows Dear, At 13:47 4/01/2006, you wrote: Hi...=20 When i am trying to connect to the database in the local = windows system where database server is running as service=20 I am getting the following error message.=20 =20 Connection to database failed=20 FATAL: no pg_hba.conf entry for host "10.0.0.205", user = "postgres", database "pilot", SSL off=20 Press any key to continue=20 =20 The following is there in pg_hba.conf.sample file=20 =20 @authcomment@=20 =20 # TYPE DATABASE USER CIDR-ADDRESS METHOD=20 =20 @remove-line-for-nolocal@# "local" is for Unix domain socket = connections only=20 @remove-line-for-nolocal@local all all = @authmethod@=20 # IPv4 local connections:=20 host all all 127.0.0.1/32 = @authmethod@ host pilot postgres 10.0.0.205/32 md5 # IPv6 local connections:=20 host all all ::1/128 = @authmethod@=20 =20 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.=20 Please suggest me how to proceed. =20 Thank you... =20 -Sandhya Do not forget pg_ctl reload -D /your_path_to_the_data Kind Regards Patrick ------=_NextPart_000_006D_01C612AC.6A278E90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear patrick...........
 
Thank you for your help.
When i tried it i am getting the = following=20 message.
postmaster = signaled
why is it so?pls explain me = ....
What i need to do for = this.
While connecting to the database if i = am giving it=20 as local host it is considering and when i tried to give IP of that M/C = it is=20 giving error.
I have added the line what u = said.
 
@authcomment@=20
# TYPE  DATABASE   =20 USER       =20 CIDR-ADDRESS          = METHOD=20
@remove-line-for-nolocal@# "local" is = for Unix=20 domain socket connections only=20
@remove-line-for-nolocal@local  =20 all        =20 all           &nbs= p;            = ;      =20 @authmethod@=20
# IPv4 local connections:=20
host    = all        =20 all        =20 127.0.0.1/32         =20 @authmethod@
host   =20 pilot      =20 postgres       =20 10.0.0.205/32     md5

# IPv6 local connections:=20
host    = all        =20 all        =20 = ::1/128           =    =20 @authmethod@=20
Please tell = me.....
-Sandhya
 
 
----- Original Message -----
From:=20 Patrick Meylemans
To: sandhya
Sent: Friday, January 06, 2006 = 12:33=20 AM
Subject: Re: [ADMIN] reg db = access from=20 windows

Hi,

Best is to log in as te user who owns the = database=20 (standard this should be postgres I assume).

Then you open a = "dos=20 box"  -> start run cmd

Then you type the following=20 command

c:\Program Files\PostgreSQL\8.1\bin\pg_ctl reload -D=20 c:\your_path_to_the_database

A standard install is placing the=20 databases at the following location :

c:\Program=20 Files\Postgresql\8.1\data

So  the command will=20 be

c:\Program Files\Postgresql\8.1\bin\pg_ctl reload -D = c:/Program=20 Files/Postgresql/8.1/data

Kind regards

Patrick

At = 05:52=20 5/01/2006, you wrote:
I am=20 using windows.U have mentioned about pg_ctl reload.
In windows = where i=20 should give this command.
Is it in the below path=20 mentioned...?
postgresql-8.0.0\src\bin\pg_ctl
Please = tell=20 me.
 
-Sandhya
---- Original Message -----
From: Patrick = Meylemans
To: sandhya =
Sent: Wednesday, January 04, 2006 7:27 PM
Subject: Re: [ADMIN] reg db access from windows

Hi ...

Best to do is to fire the command from the user who installed = the=20 database.

In the startup files you can see the location of your data = directory=20 ..

Is it a win box or a Linux machine ?

CU

Patrick
At 14:15 4/01/2006, you wrote:
hi....
Do not forget pg_ctl reload -D /your_path_to_the_data
where i need to give this pg_ctl reload
whether in the below path or=20 where?
postgresql-8.0.0\src\bin\pg_ctl
thanks,
Sandhya
=20
----- Original Message -----=20
From: Patrick=20 Meylemans=20
To: sandhya=20
Sent: Wednesday, January 04, 2006 6:24 PM=20
Subject: Re: [ADMIN] reg db access from windows
Dear,
At 13:47 4/01/2006, you wrote:
Hi...=20
 When i am trying to connect to the database in the = local=20 windows system where database server is running as service=20
I am getting the following error message.=20
=20
Connection to database failed=20
FATAL:  no pg_hba.conf entry for host "10.0.0.205", = user=20 "postgres", database "pilot", SSL off=20
Press any key to continue=20
=20
The following is there in=20 pg_hba.conf.sample file=20
=20
@authcomment@=20
=20
# TYPE  = DATABASE   =20 USER       =20 = CIDR-ADDRESS         =20 METHOD=20
=20
@remove-line-for-nolocal@# = "local" is for=20 Unix domain socket connections only=20
@remove-line-for-nolocal@local  =20 all        =20 = all           &nbs= p;            = ;      =20 @authmethod@=20
# IPv4 local connections:=20
host   =20 all        =20 all        =20 = 127.0.0.1/32         =20 @authmethod@
host   =20 pilot      =20 postgres       =20 10.0.0.205/32     md5

# IPv6 local connections:=20
host   =20 all        =20 all        =20 = ::1/128           =    =20 @authmethod@=20
=20
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.=20
Please suggest me how to proceed.
=20
Thank you...
=20
-Sandhya

Do not forget pg_ctl reload -D /your_path_to_the_data
Kind Regards
=
Patrick

= ------=_NextPart_000_006D_01C612AC.6A278E90--