Re: scripting vacuum

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