"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > is there anyway of specifying password in the command line interface > of pg_dumpall??
No, and you wouldn't want to use it if there was (hint: putting a password on a command line is insecure). The recommended procedure to avoid a lot of password prompts is to set up a ~/.pgpass file: http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
