Re: Postgresql and shell script

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux