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