Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-04-03 Thread Bruno Wolff III
On Tue, Mar 29, 2005 at 03:54:48 +0100, Olivier Thauvin <[EMAIL PROTECTED]> wrote: > > Maybe I will workaround by setting postgres user access as 'trust' for local > connection only, but I have to reread the doc before :). Ident is better if you can use domain sockets and the equivalent of get

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-04-02 Thread Olivier Thauvin
Le Tuesday 29 March 2005 00:40, vous avez écrit : > The typical way to do this is to use .pgpass in the user's home > directory. Does that help? Yes it help, but: - please notice the issue about ps into the README - the .pgpass doesn't work on my configuration: [EMAIL PROTECTED] pgsql]$ pg_autov

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-30 Thread Bruce Momjian
Neil Conway wrote: > Alvaro Herrera wrote: > > I believe on Windows the file is called pgpass.conf instead? > > The SGML docs pretty consistently only mention "~/.pgpass" when > referencing this feature, so I didn't bother mentioning the other name > in the pg_autovacuum README. Perhaps someone

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-30 Thread Neil Conway
Alvaro Herrera wrote: I believe on Windows the file is called pgpass.conf instead? The SGML docs pretty consistently only mention "~/.pgpass" when referencing this feature, so I didn't bother mentioning the other name in the pg_autovacuum README. Perhaps someone should fix the SGML docs to refer

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-30 Thread Alvaro Herrera
On Wed, Mar 30, 2005 at 03:06:44PM +1000, Neil Conway wrote: > Matthew T. O'Connor wrote: > >I believe that pg_autovacuum will work with a .pgpass file just like any > >libpq based application. > > It should, yes. I've applied the attached patch to HEAD and > REL8_0_STABLE that makes the securit

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-29 Thread Neil Conway
Matthew T. O'Connor wrote: I believe that pg_autovacuum will work with a .pgpass file just like any libpq based application. It should, yes. I've applied the attached patch to HEAD and REL8_0_STABLE that makes the security warning about -P more broad, and suggests using ~/.pgpass instead. -Neil

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-28 Thread Bruce Momjian
The typical way to do this is to use .pgpass in the user's home directory. Does that help? --- Olivier Thauvin wrote: > > The following bug has been logged online: > > Bug reference: 1567 > Logged by: Olivie

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-26 Thread Matthew T. O'Connor
I believe that pg_autovacuum will work with a .pgpass file just like any libpq based application. Olivier Thauvin wrote: The following bug has been logged online: Bug reference: 1567 Logged by: Olivier Thauvin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating

[BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-26 Thread Olivier Thauvin
The following bug has been logged online: Bug reference: 1567 Logged by: Olivier Thauvin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux (Mandrake cooker) Description:can't hide password with pg_autovacuum Details: I found an secur