Re: Postgresql and shell script

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





On 10/30/07, Clint Dilks <clintd@xxxxxxxxxxxxxxxxxx> wrote:
You could set up the User so that no password is required from Localhost
if that is appropriate


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>
>
>
> Tronn
> ------------------------------------------------------------------------
>
> _______________________________________________
> CentOS mailing list
> CentOS@xxxxxxxxxx
> http://lists.centos.org/mailman/listinfo/centos
>

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos



Yes that is a possiblity, Joachim I dont see how this can be accomplished with sudo, could you provide some example syntax

Tronn
_______________________________________________
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