Re: psql Automatic login In Bash Script

From: Peter Eisentraut <peter(dot)eisentraut(at)credativ(dot)de>
To: aspire420(at)hotpop(dot)com, Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>, pgsql-admin(at)postgresql(dot)org
Subject: Re: psql Automatic login In Bash Script
Date: 2004-01-13 19:47:28
Message-ID: 200401132047.28432.peter.eisentraut@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sai Hertz And Control Systems 2004-01-13 19:47:41 psql Automatic login In Bash Script
Previous Message Manuel Sugawara 2004-01-13 19:28:19 Re: Error on system startup