Re: Sharing /etc/passwd with PostgreSQL

From: Scott Marlowe <scott(dot)marlowe(at)gmail(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:24:13
Message-ID: dcc563d10908071724q416e88f7x281798c8d760c5db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-08 00:27:43 Re: Sharing /etc/passwd with PostgreSQL
Previous Message Kevin Grittner 2009-08-07 14:48:37 Re: Used ports