Re: scripting vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Kelly <akelly(at)transparency(dot)org>
Cc: postgres <pgsql-novice(at)postgresql(dot)org>
Subject: Re: scripting vacuum
Date: 2004-05-05 12:26:33
Message-ID: 24506.1083759993@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Andrew Kelly <akelly(at)transparency(dot)org> writes:
> is my only hope of success to use 'expect', or is there a way
> pass the pw as an arg to vacuumdb?

Put the password in the Postgres user's ~/.pgpass file.

> You know, something like
> local:username all trust

If you can't do that then you should consider updating to a more recent
version of Postgres. But I'd advise against writing it quite that way,
since the above would let anyone on the local machine into your
database --- they just have to claim to be the postgres user via -U.
You might be able to use "ident" authentication safely, though, if your
platform supports it on local connections.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message M. Bastin 2004-05-05 13:13:38 Re: How to set up an SSL test environment?
Previous Message Andrew Kelly 2004-05-05 11:16:41 scripting vacuum