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--