Re: psql Automatic login In Bash Script - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: psql Automatic login In Bash Script
Date
Msg-id 200401132047.28432.peter.eisentraut@credativ.de
Whole thread Raw
In response to psql Automatic login In Bash Script  (Sai Hertz And Control Systems <sank89@sancharnet.in>)
List pgsql-admin
Sai Hertz And Control Systems wrote:
> What I need is since password be stored in the bash variable for
> once I may pass on the variable with password to
> psql
> pg_dump
> pg_restore
> and my database migration would go smothly

That would be a security hole because then other users can read the
password using 'ps'.

> Also would not like to set ~/.pgpass

Why not?  That's what it's for.


pgsql-admin by date:

Previous
From: Leslie
Date:
Subject: Re: Are there programs to graph database schema?
Next
From: Max Grigoriev
Date:
Subject: Pg_restore qusetion