Error connecting using pgadmin from different computer !!

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Goutam Paruchuri
    #1

    Error connecting using pgadmin from different computer !!

    Hello,

    I get an error in my log when connecting to postgres server on Windows.
    Postgres version : 8.0.0-beta4

    LOG TEXT

    2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
    Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
    "192.168.2. 1/254"
    2004-11-10 11:22:47 FATAL: missing or erroneous pg_hba.conf file
    2004-11-10 11:22:47 HINT: See server log for details.

    Configuration file pg_hba.conf

    host all all 192.168.2.1/254 md5
    host all all 127.0.0.1/32 md5

    Any ideas how to fix it ??

    Thanks !
    Goutam




    Confidentiality Notice
    The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.


    ---------------------------(end of broadcast)---------------------------
    TIP 4: Don't 'kill -9' the postmaster

    Tags: None
    • Russell Smith
      #2
      Re: Error connecting using pgadmin from different computer !!

      On Thu, 11 Nov 2004 03:31 am, Goutam Paruchuri wrote:[color=blue]
      > Hello,
      >
      > I get an error in my log when connecting to postgres server on Windows.
      > Postgres version : 8.0.0-beta4
      >
      > LOG TEXT
      >
      > 2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
      > Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
      > "192.168.2. 1/254"
      > 2004-11-10 11:22:47 FATAL: missing or erroneous pg_hba.conf file
      > 2004-11-10 11:22:47 HINT: See server log for details.
      >
      > Configuration file pg_hba.conf
      >
      > host all all 192.168.2.1/254 md5[/color]
      /254 <- that is not a valid subnet mask. /0 - /32 are valid, did you mean /31?
      [color=blue]
      > host all all 127.0.0.1/32 md5
      >
      > Any ideas how to fix it ??
      >
      > Thanks !
      > Goutam
      >
      >
      >
      >
      > Confidentiality Notice
      > The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.
      >
      >
      > ---------------------------(end of broadcast)---------------------------
      > TIP 4: Don't 'kill -9' the postmaster
      >
      >[/color]

      ---------------------------(end of broadcast)---------------------------
      TIP 2: you can get off all lists at once with the unregister command
      (send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

        Comment

        Previous template Next
        Working...