Andrew Kelly <akelly@transparency.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