Re: Pg_dumpall problem[2]

Bruno Wolff III <bruno@wolff.to> writes:
>> Run psql script.  You can use PGPASSWORD environment variable. Search
>> archives. It has the references..

> This isn't a good idea. If you are worried enough about local users
> to use password authentication, you don't want to put passwords into
> environment variables as on most unix systems they are visible to other
> users.

Yeah.  In 7.3, you can keep passwords in ~/.pgpass instead; much more secure.

            regards, tom lane