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
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@centos.org http://lists.centos.org/mailman/listinfo/centos
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@centos.org http://lists.centos.org/mailman/listinfo/centos
On 10/30/07, Clint Dilks clintd@scms.waikato.ac.nz 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@centos.org http://lists.centos.org/mailman/listinfo/centos
CentOS mailing list CentOS@centos.org 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
On Tue, 2007-10-30 at 12:37 +0100, Tronn Wærdahl wrote:
Yes that is a possiblity, Joachim I dont see how this can be accomplished with sudo, could you provide some example syntax
You could use the environment variable PGPASSWORD to connect to the database without entering the password. Or you could use the .pgpass file as explained here: http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html
Tronn
ciao andrea
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 10/30/07, Tronn Wærdahl wrote:
PG_passwd=secret PG_user =username PG_database=simple
sudo and .pgpass would be better, but for future reference, just source the file in your script.
#!/bin/sh source $HOME/.mypgvars
Now your PG_* variables have values...
- -- Andy Harrison public key: 0x67518262
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
-
Andrea Dell'Amico -
Andy Harrison -
Clint Dilks -
Craig White -
Joachim Backes -
Tronn Wærdahl