Обсуждение: psql Automatic login In Bash Script
Dear all , I know this is a wrong list to for this post Anyways We use bash script for database maintainace and implimenting new schema in the production database the script goes as <code> #!/bin/sh until [ "$uname" ] do read -s uname done until [ "$pass" ] do read -s pass done psql -U $uname mydatabase -f ./my_functions.sql psql -U $uname mydatabase -f ./my_tables.sql psql -U $uname mydatabase -f ./my_views.sql </code> The problem is psql has no option such that I can pass on the variable $pass for password and as you can see I have to type in password three times (in real case 10 times) What I need is since password be stored in the bash variable for once I may pass on the variable with password to psql pg_dump pg_restore and my database migration would go smothly Also would not like to set ~/.pgpass Would be greateful to you all for any kinda help . Regards, Vishal Kashyap
Dear Peter Eisentraut >>and my database migration would go smothly >> >> > >That would be a security hole because then other users can read the >password using 'ps'. > >>Also would not like to set ~/.pgpass >>Why not? That's what it's for. >> >> Agreed and now we decided to use it but will ~/.pgpass work for pg_dump pg_restore Regards, Vishal Kashyap
Sai Hertz And Control Systems wrote: > Agreed and now we decided to use it but will ~/.pgpass work for > pg_dump > pg_restore Yes, it works for all libpq programs.
Dear Peter Eisentraut , Loads of thanks for you kind and much needed help. Best Regards, Vishal Kashyap >>Agreed and now we decided to use it but will ~/.pgpass work for >>pg_dump >>pg_restore >> >> > >Yes, it works for all libpq programs. > > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > > >
Sai Hertz And Control Systems wrote: > What I need is since password be stored in the bash variable for > once I may pass on the variable with password to > psql > pg_dump > pg_restore > and my database migration would go smothly That would be a security hole because then other users can read the password using 'ps'. > Also would not like to set ~/.pgpass Why not? That's what it's for.