Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] pg_autovacuum commandline password hiding.

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Ian FREISLICH" <if(at)hetzner(dot)co(dot)za>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCH] pg_autovacuum commandline password hiding.
Date: 2005-05-24 14:36:45
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E490E088@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-patches
 

> -----Original Message-----
> From: pgsql-patches-owner(at)postgresql(dot)org 
> [mailto:pgsql-patches-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 24 May 2005 15:17
> To: Ian FREISLICH
> Cc: pgsql-patches(at)postgresql(dot)org
> Subject: Re: [PATCHES] [PATCH] pg_autovacuum commandline 
> password hiding. 
> 
> Ian FREISLICH <if(at)hetzner(dot)co(dot)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(at)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.

Responses

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2005-05-24 14:41:56
Subject: Re: plperl strict mode
Previous:From: Tom LaneDate: 2005-05-24 14:16:58
Subject: Re: [PATCH] pg_autovacuum commandline password hiding.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group