Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group