Re: .pgpass and root: a problem - Mailing list pgsql-general

From Jasen Betts
Subject Re: .pgpass and root: a problem
Date
Msg-id kesngq$ji5$1@gonzo.reversiblemaps.ath.cx
Whole thread Raw
In response to .pgpass and root: a problem  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-general
On 2013-02-05, Scott Mead <scottm@openscg.com> wrote:

> I would love to see pgpass storing encrypted stuff here, that'd be great...
> in the meantime...

whatever it stores will, of necessity, be sufficient to grant access to the
postgres database, libpq could be modified to use MD5 hashed passwords
in that file salted with the username. But that won't make the databse
any more secure.

>  Is there any way that you could move your 'root-fellas' to a 'sudo' model
> so that they can have *most* of what they need, without allowing identity
> switches ?  I was trying to come up with something clever, but if they're
> root, they're root.

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Ben Madin
Date:
Subject: Re: ERROR: invalid input syntax for integer: "" - more confusion
Next
From: Adrian Klaver
Date:
Subject: Re: ERROR: invalid input syntax for integer: ""