Path: csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Dimitri Fontaine 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: References: 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 Scott Ellis 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