From: sandhya <sandhyar@amiindia.co.in>
To: Patrick Meylemans <Patrick.Meylemans@wtcm.be>
Cc: postgre <pgsql-admin@postgresql.org>
Cc: sandhya <sandhyar@amiindia.co.in>
Subject: Re: reg db access from windows
Date: Fri, 6 Jan 2006 10:31:55 +0530
Message-ID: <007001c6127e$50a7eec0$cd00000a@amiindiahjwbgh> (raw)
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>
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@
# 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@
host pilot postgres 10.0.0.205/32 md5
# IPv6 local connections:
host all all ::1/128 @authmethod@
Please tell me.....
-Sandhya
----- Original Message -----
From: Patrick Meylemans
To: sandhya
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.
-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 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
whether in the below path or where?
postgresql-8.0.0\src\bin\pg_ctl
thanks,
Sandhya
----- Original Message -----
From: Patrick Meylemans
To: sandhya
Sent: Wednesday, January 04, 2006 6:24 PM
Subject: Re: [ADMIN] reg db access from windows
Dear,
At 13:47 4/01/2006, you wrote:
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@
host pilot postgres 10.0.0.205/32 md5
# 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
Do not forget pg_ctl reload -D /your_path_to_the_data
Kind Regards
Patrick
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: sandhyar@amiindia.co.in, Patrick.Meylemans@wtcm.be
Subject: Re: reg db access from windows
In-Reply-To: <007001c6127e$50a7eec0$cd00000a@amiindiahjwbgh>
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> <007001c6127e$50a7eec0$cd00000a@amiindiahjwbgh>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox