| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgres wish list |
| Date: | 2009-02-21 13:04:12 |
| Message-ID: | 20090221130412.GB1732@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 20, 2009 at 09:50:25AM +0000, Jasen Betts wrote:
> by the default authentication for unix domain sockets is "ident" which
> (AIUI) requires the caller have the a unix username that matches their
> postgres username, but you can change that to "md5" (password based)
> or "trust" (no authentication) in pg_hba.conf
With ident auth you can also specify a mapping file, which lists which
UNIX users can connect as which postgresql users without password. An
extremely useful feature.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-02-21 17:20:25 | Re: Fixing invalid owners on pg_toast tables in 8.3.5 |
| Previous Message | John R Pierce | 2009-02-21 09:58:18 | Re: How to import/setup library functins |