Re: Trouble setting up access privileges - Mailing list pgsql-admin

From Tom Lane
Subject Re: Trouble setting up access privileges
Date
Msg-id 508.1221498488@sss.pgh.pa.us
Whole thread Raw
In response to Trouble setting up access privileges  (mkrist@binf.ku.dk)
Responses Re: Trouble setting up access privileges  (mkrist@binf.ku.dk)
List pgsql-admin
mkrist@binf.ku.dk writes:
> The relevant line in pg_hba.conf is this:
> host    all         mette,mkrist       10.10.0.0        255.255.0.0       md5

What are the *other* lines in pg_hba.conf?

> I can't find anything in the documentation about exceptions from the
> pg_hba.conf rules,

There aren't any.  The likely explanations are that (1) some earlier
line in pg_hba.conf is capturing the connection, (2) you are looking
at the wrong copy of pg_hba.conf, (3) you edited pg_hba.conf but
forgot to SIGHUP the postmaster, (4) you have a ~/.pgpass file on
the client side that is silently supplying a password in some of
these cases.

            regards, tom lane

pgsql-admin by date:

Previous
From: "c k"
Date:
Subject: Functions
Next
From: mkrist@binf.ku.dk
Date:
Subject: Re: Trouble setting up access privileges