Re: scripting vacuum

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