pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_hba and *
2+ messages / 2 participants
[nested] [flat]

* pg_hba and *
@ 2004-12-16 15:52  FM <dist-list@LEXUM.UMontreal.CA>
  0 siblings, 1 reply; 2+ messages in thread

From: FM @ 2004-12-16 15:52 UTC (permalink / raw)
  To: pgsql-admin

Hello,
We have kerberos auth for all humain users, but I still need md5 auth 
for scripts users.

All my scripts user name start with soft_

Can I add soft_* in the pg_hba ?

thanks



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_hba and *
@ 2004-12-16 17:23  Bruno Wolff III <bruno@wolff.to>
  parent: FM <dist-list@LEXUM.UMontreal.CA>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2004-12-16 17:23 UTC (permalink / raw)
  To: FM <dist-list@LEXUM.UMontreal.CA>; +Cc: pgsql-admin

On Thu, Dec 16, 2004 at 10:52:31 -0500,
  FM <dist-list@LEXUM.UMontreal.CA> wrote:
> Hello,
> We have kerberos auth for all humain users, but I still need md5 auth 
> for scripts users.
> 
> All my scripts user name start with soft_
> 
> Can I add soft_* in the pg_hba ?

You can't do pattern matching there.

It probably wouldn't be that hard to make a custom change to allow
some sort of pattern matching.

Another option would be to have a script that updates pg_hba.conf
as needed (and signal the server).

Yet another possible option (if the scripts are only run from the server)
is to use md5 for domain socket connections and kerberos for tcp/ip
connections.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-12-16 17:23 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-16 15:52 pg_hba and * FM <dist-list@LEXUM.UMontreal.CA>
2004-12-16 17:23 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox