pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
reg db access from windows
3+ messages / 1 participants
[nested] [flat]

* reg db access from windows
@ 2006-01-04 12:47 sandhya <sandhyar@amiindia.co.in>
  2006-01-04 13:06 ` Re: reg db access from windows sandhya <sandhyar@amiindia.co.in>
  2006-01-06 05:01 ` Re: reg db access from windows sandhya <sandhyar@amiindia.co.in>
  0 siblings, 2 replies; 3+ messages in thread

From: sandhya @ 2006-01-04 12:47 UTC (permalink / raw)
  To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: reg db access from windows
  2006-01-04 12:47 reg db access from windows sandhya <sandhyar@amiindia.co.in>
@ 2006-01-04 13:06 ` sandhya <sandhyar@amiindia.co.in>
  1 sibling, 0 replies; 3+ messages in thread

From: sandhya @ 2006-01-04 13:06 UTC (permalink / raw)
  To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>

If i am using local host......Should we not use IP addree of that .
like:
char ConnInfo[]={"dbname=pilot user=postgres password=megarac host=localhost port=5432"};

When iam giving host = 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 ----- 
  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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: reg db access from windows
  2006-01-04 12:47 reg db access from windows sandhya <sandhyar@amiindia.co.in>
@ 2006-01-06 05:01 ` sandhya <sandhyar@amiindia.co.in>
  1 sibling, 0 replies; 3+ messages in thread

From: sandhya @ 2006-01-06 05:01 UTC (permalink / raw)
  To: Patrick Meylemans <Patrick.Meylemans@wtcm.be>; +Cc: pgsql-admin; sandhya <sandhyar@amiindia.co.in>

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-01-06 05:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-04 12:47 reg db access from windows sandhya <sandhyar@amiindia.co.in>
2006-01-04 13:06 ` sandhya <sandhyar@amiindia.co.in>
2006-01-06 05:01 ` sandhya <sandhyar@amiindia.co.in>

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