I've password protected the 'postgres' account (to enable secure remote access) and I don't want to store the password on the local file system. I therefore want to create a separate account for use by pg_autovacuum (locked down in pg_hba.conf and perhaps with a password). What are the minimum set of privileges needed by pg_autovacuum? I've searched extensively & can't find an answer. -- Peter Fein pfein@xxxxxxxxx 773-575-0694 Basically, if you're not a utopianist, you're a schmuck. -J. Feldman ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match