postgres-user <-> unix user

Tomas B. Winkler writes:

I would like to allow any user which has an unix account in our system to
be able to connect a DB. Can be postgres configured that an unix user
become automatically also a postgres user ? I can figure out some ways
to do it yet I'm looking for the most transparent one.
Thanks a lot.

Use ident authentication with a map name of "sameuser". See the
documentation in the file pg_hba.conf.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

On Tue, 19 Sep 2000, Tomas B. Winkler wrote:

I would like to allow any user which has an unix account in our system to
be able to connect a DB. Can be postgres configured that an unix user
become automatically also a postgres user ? I can figure out some ways
to do it yet I'm looking for the most transparent one.

Back in my Oracle days on IBM RS6000 I seem to remember we had to manually
add the user as an Oarcle user. This included sometimes two accounts.
The normal user and an OPS$usename account so they could login
automagically to an Oracle instance.
Basically I think you'll need to add them as part of the adduser/useradd
process and/or run a script against the passwd file to create them.

rod
--
Roderick A. Anderson
raanders@altoplanos.net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814

I haven't found any documentation about pg_ident.conf file format.

Tomas Winkler
The System Group
CSE HUJI

On Tue, 19 Sep 2000, Peter Eisentraut wrote:

Tomas B. Winkler writes:

I haven't found any documentation about pg_ident.conf file format.

It contains lines of the form

mapname unixname postgres-name

but if you use the map "sameuser" you don't need it.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/