Home > Archive > PostgreSQL Bugs > March 2005 > Re: BUG #1567: can't hide password with pg_autovacuum









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: BUG #1567: can't hide password with pg_autovacuum
Neil Conway

2005-03-30, 9:42 am

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

Alvaro Herrera

2005-03-30, 9:42 am

On Wed, Mar 30, 2005 at 03:06:44PM +1000, Neil Conway wrote:
> Matthew T. O'Connor wrote:
>
> 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.


I believe on Windows the file is called pgpass.conf instead?

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl> )
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Neil Conway

2005-03-30, 9:42 am

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 to both, or perhaps to speak in terms of a general "libpq password
file" feature or some such.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Bruce Momjian

2005-03-31, 7:02 am

Neil Conway wrote:
> Alvaro Herrera wrote:
>
> 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 to both, or perhaps to speak in terms of a general "libpq password
> file" feature or some such.


Every place the docs mention just .pgpass they reference the section on
pgpass, which shows the Win32 naming. Seems OK to me.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com