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> > I think, the usage of sudo would solve your problem. Regards Joachim Backes > 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 > > > ------------------------------------------------------------------------ > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos -- Joachim Backes <joachim.backes at rhrk.uni-kl.de> University of Kaiserslautern,Computer Center [RHRK], Systems and Operations, High Performance Computing, D-67653 Kaiserslautern, PO Box 3049, Germany -------------------------------------------------- Phone: +49-631-205-2438, FAX: +49-631-205-3056 http://hlrwm.rhrk.uni-kl.de/home/staff/backes.html -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/x-pkcs7-signature Size: 6088 bytes Desc: S/MIME Cryptographic Signature URL: <http://lists.centos.org/pipermail/centos/attachments/20071030/048592d0/attachment-0005.bin>