[CentOS] Postgresql and shell script

Tue Oct 30 11:05:27 UTC 2007
Tronn Wærdahl <tronnw at gmail.com>

I have a shell script (sh) where I create a user and import data to a
postgres database

<snip>
su -c "createuser -A -D -P $PG_user" postgres
su -c "psql -d$PG_database -h localhost -U$PG_user -W -f postgresql.sql "
postgres
</snip>

when the script executes those command, it ask for a password, how could I
do this without have to enter the passwd, I would like that it reads the
password from a variabel, that excists in a separate file, like

<variable file>
PG_passwd=secret
PG_user =username
PG_database=simple
</variable file>


Tronn
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20071030/adab1ffc/attachment-0004.html>