Re: pg_dump password

Q Beukes <pgsql-novice@list.za.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