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