Re: [PATCH] pg_autovacuum commandline password hiding. - Mailing list pgsql-patches

From Neil Conway
Subject Re: [PATCH] pg_autovacuum commandline password hiding.
Date
Msg-id 4293E7C6.6070603@samurai.com
Whole thread Raw
In response to Re: [PATCH] pg_autovacuum commandline password hiding.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] pg_autovacuum commandline password hiding.
List pgsql-patches
Tom Lane wrote:
> The question at hand is whether we want to support an obvious security
> hole.  The argument that "some people will not care" applies with at
> least as much force to psql or pg_dump, which at least have the grace
> to not hang around and advertise their command-line parameters forever.
> I think that using -P for pg_autovacuum is just plain stupid, even on a
> nominally secure single-user box.

Assuming that command-line parameters are actually globally visible on
your platform, which isn't necessarily the case.

Anyway, I basically agree that the legitimate use-case for this feature
is pretty small, and it is probably worth removing. However, I don't
think it is urgent (there are plenty of other ways to shoot yourself in
the foot), and shouldn't be backpatched -- people may be using this
functionality.

-Neil

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] pg_autovacuum commandline password hiding.
Next
From: Neil Conway
Date:
Subject: Re: fix a bogus line in dynahash.c