Re: Sharing /etc/passwd with PostgreSQL

On Fri, Aug 7, 2009 at 8:08 AM, Eamonn Martin<mas01em@gold.ac.uk> 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?

Yep, it's definitely the case.  You could look into using LDAP for
authentication of both your users on regular unix type accounts and
pgsql users.