Re: keywords on .pgpass

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: keywords on .pgpass
Date: 2009-12-25 12:56:40
Message-ID: 4B34B688.5030502@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fujii Masao wrote:
> Hi,
>
> pg_hba.conf accepts some keywords like 'all', 'sameuser' and so on.
> Likewise, I'd like to support the same keywords for .pgpass file.
> Thought?
>
>
>

I don't see the use case for it - .pgpass is for single users, not a
whole cluster. And it does support wildcards, which takes care of the
'all' case. In the case of pg_hba.conf we don't know in advance who will
actually be connecting. But in the case of .pgpass we do, so the extra
utility of 'sameuser', 'samerole' and 'samegroup' in this case is not
apparent to me.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-12-25 15:12:35 Re: Removing pg_migrator limitations
Previous Message Manan Nayak 2009-12-25 10:37:00 Reg postgresSQL source code