Re: Trouble setting up access privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mkrist(at)binf(dot)ku(dot)dk
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Trouble setting up access privileges
Date: 2008-09-15 17:08:08
Message-ID: 508.1221498488@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

mkrist(at)binf(dot)ku(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mkrist 2008-09-15 17:41:37 Re: Trouble setting up access privileges
Previous Message c k 2008-09-15 16:55:38 Functions