Thread: reg db access from windows

----- Original Message -----

From: sandhya

To: postgre

Cc: sandhya

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

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