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

> -----Original Message-----
> From: pgsql-patches-owner@postgresql.org
> [mailto:pgsql-patches-owner@postgresql.org] On Behalf Of Tom Lane
> Sent: 24 May 2005 15:17
> To: Ian FREISLICH
> Cc: pgsql-patches@postgresql.org
> Subject: Re: [PATCHES] [PATCH] pg_autovacuum commandline
> password hiding.
>
> Ian FREISLICH <if@hetzner.co.za> writes:
> > ...  The only thing is that
> > pg_autovacuum keeps the password supplied on the commandline so
> > anyone that does a 'ps' can get the database superuser password.
>
> Which is exactly why we don't (and won't) provide such a switch.

Err, yes we do:

root@zankou:~# ~postgres/bin/pg_autovacuum -h
usage: pg_autovacuum
   [-D] Daemonize (Detach from tty and run in the background)
   [-d] debug (debug level=0,1,2,3; default=0)
   [-s] sleep base value (default=300)
   [-S] sleep scaling factor (default=2.000000)
   [-v] vacuum base threshold (default=1000)
   [-V] vacuum scaling factor (default=2.000000)
   [-a] analyze base threshold (default=500)
   [-A] analyze scaling factor (default=1.000000)
   [-L] logfile (default=none)
   [-c] vacuum_cost_delay (default=none)
   [-C] vacuum_cost_page_hit (default=none)
   [-m] vacuum_cost_page_miss (default=none)
   [-n] vacuum_cost_page_dirty (default=none)
   [-l] vacuum_cost_limit (default=none)
   [-U] username (libpq default)
   [-P] password (libpq default)
   [-H] host (libpq default)
   [-p] port (libpq default)
   [-h] help (Show this output)

:-(

Regards, Dave.