[CentOS] Postgresql and shell script

Tue Oct 30 11:09:54 UTC 2007
Joachim Backes <joachim.backes at rhrk.uni-kl.de>

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>