Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #716

Re: Granting linux users database access

Path csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups comp.databases.postgresql
Subject Re: Granting linux users database access
Date Tue, 07 Jun 2016 10:06:38 +0200
Organization A noiseless patient Spider
Lines 13
Message-ID <m2ziqxpgmp.fsf@2ndQuadrant.fr> (permalink)
References <abf261a9-1c72-4e90-8c11-9d30d254e1ba@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain
Injection-Info mx02.eternal-september.org; posting-host="1d4e32905d8c3b3f9165311ae7981c1f"; logging-data="15069"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18QPA0xeSnTbZgxdH/mmFzA"
User-Agent Gnus/5.13001 (Ma Gnus v0.10) Emacs/24.5 (darwin)
Cancel-Lock sha1:rlc7iZeOGoJV51wHuNpxFbLk1w4= sha1:u1dbiAHL3pKMqBL8hnyJH0sEruU=
Xref csiph.com comp.databases.postgresql:716

Show key headers only | 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 | NextPrevious 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