Re: pg_dump password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Q Beukes <pgsql-novice(at)list(dot)za(dot)net>
Cc: Postgresql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pg_dump password
Date: 2006-09-13 15:10:08
Message-ID: 11743.1158160208@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lan Barnes 2006-09-13 16:28:59 Re: pg_dump password
Previous Message Richard Broersma Jr 2006-09-13 14:51:38 Re: problems connecting remote postgresql server