| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Pg_dumpall problem[2] |
| Date: | 2003-02-07 15:41:44 |
| Message-ID: | 27788.1044632504@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruno Wolff III <bruno(at)wolff(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chris.gamble | 2003-02-07 16:18:56 | Seeking advice on database table design for storing images |
| Previous Message | Tom Lane | 2003-02-07 15:35:42 | Re: converting Oracle to postgres |