Re: Sharing /etc/passwd with PostgreSQL

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Eamonn Martin <mas01em(at)gold(dot)ac(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Sharing /etc/passwd with PostgreSQL
Date: 2009-08-08 00:27:43
Message-ID: 20090808002743.GL5290@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Eamonn Martin wrote:
>
> Hi,
>
> Could someone confirm that the ability to share the Linux system
> /etc/passwd (or shadow) file with PostgreSQL is definitely defunct?
>
> I've searched the archives and, as far as I can tell, this
> functionality was removed after version 7.2 as "few were using it".
> Well we were using it and we have thus been stuck with using version
> 7.2 ever since. We'd really like to finally upgrade to version 8
> but would rather not create separate passwords for everyone unless
> we really have no choice. Is this definitely the case?

You can authenticate users with PAM, which amounts more or less to the
same thing.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-08-08 00:40:25 Re: Sharing /etc/passwd with PostgreSQL
Previous Message Scott Marlowe 2009-08-08 00:24:13 Re: Sharing /etc/passwd with PostgreSQL