Обсуждение: pg_hba.conf with the "password" auth failed to work sometimes...

Hello all,

    i'm using the version 7.0.3 on Redhat 7.1.

    i found sometimes when i setup the pg_hba.conf
    to restrict to only allow a client from certain
    ip to access a database with password auth, but
    i found even i give an invalid password, the
    client still can connect to this database.

    pg_hba.conf
    -----------
    host  mydb  192.168.0.100  255.255.255.0  password  user.hba

    user.hba
    ----------
    user:


    any idea?

---

Wong Ka Ho Matthew
System Engineer
Sky Telemedia Limited
Tel: (852) 2845 8315
Fax: (852) 2845 7890
email: mattheww@skytelemedia.com

matthew wong <mattheww@skytelemedia.com> writes:
>     i found sometimes when i setup the pg_hba.conf
>     to restrict to only allow a client from certain
>     ip to access a database with password auth, but
>     i found even i give an invalid password, the
>     client still can connect to this database.

Is there another line in pg_hba.conf that might allow this client
to connect?  The postmaster will use the first entry that matches
the connection source address and target database...

            regards, tom lane