On Tue, 2007-10-30 at 12:05 +0100, Tronn Wærdahl wrote:
> 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>
----
not at all an answer to your question but what I have found to be useful
is to use this in /var/lib/pgsql/data/pg_hba.conf
host all all 192.168.1.0/24 pam
which means that if the user exists and has his own database in
postgres, the user authenticates against the normal auth system (pam)
which is set to auth against LDAP which means that I don't have to worry
about maintaining an extra password and if I disable the users login,
it's disabled everywhere.
Craig
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
