Q Beukes <pgsql-novice(at)list(dot)za(dot)net> writes:
> We want to close up the db so people can't alter the database, so we
> thought of using
> a password. The problem now is that we can't have pg_dump run because it
> prompts
> for a password.
Create a ~/.pgpass file for the account pg_dump runs under.
http://www.postgresql.org/docs/8.1/static/libpq-pgpass.html
regards, tom lane