Hi there,
What about a command line switch which allow the user to send password via
command line arg? For example:
./vacuumdb -U username -p password
This way vacuumdb can be run by cron without "trust"-ing any user in
pg_hba.conf.
I have patched PostgreSQL 8.0.3 source to allow password as arg for:
vacuumdb, pg_dump and pg_restore. If anyone interested please reply.
Thanks,
NosyMan