Sorry if this is a naive question. I'm using postgresql 7.2 on Linux with password authentication. I wish to issue a vaccumdb command every night via crontab. The problem is that vacuumdb always prompts for a password. How can I pass the password to vacuumdb without having to manually type it?
Sorry. Problem solved.
export PGPASSWORD=<passwd>
Kind regards,
-- Cris Carampa (spamto:[EMAIL PROTECTED])
"Poveri fanatici comunisti, noglobal e affetti dalla sindrome anti-microsoft" (gli utenti Linux secondo un poster di ICOD)
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
