Groups > comp.databases.postgresql > #716

Re: Granting linux users database access

From	Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups	comp.databases.postgresql
Subject	Re: Granting linux users database access
Date	2016-06-07 10:06 +0200
Organization	A noiseless patient Spider
Message-ID	<m2ziqxpgmp.fsf@2ndQuadrant.fr> (permalink)
References	<abf261a9-1c72-4e90-8c11-9d30d254e1ba@googlegroups.com>

Show all headers | View raw

Scott Ellis <scorellis@gmail.com> writes:
> I am trying to make it so that any user that accesses the database server
> can just login and run
>  > psql and not have to enter a password.  
>
> Is there a way to grant the linux user this style of authentication without
> having to have a database user, too? There are 10 different authentication
> methods for postgresql, and I am not sure which one does this.

It's called "peer".
-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

Granting linux users database access Scott Ellis <scorellis@gmail.com> - 2016-06-06 15:23 -0700
  Re: Granting linux users database access Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2016-06-07 10:06 +0200

csiph-web