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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend