psql Automatic login In Bash Script

[Sai Hertz And Control Systems]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Sai Hertz And Control Systems]

Dear Peter Eisentraut

Post by Sai Hertz And Control Systems
and my database migration would go smothly

That would be a security hole because then other users can read the
password using 'ps'.

Post by Sai Hertz And Control Systems
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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Peter Eisentraut]

Post by Sai Hertz And Control Systems
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]

Dear Peter Eisentraut ,

Loads of thanks for you kind and much needed help.

Best Regards,
Vishal Kashyap

Post by Peter Eisentraut

Post by Sai Hertz And Control Systems
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Peter Eisentraut]

Post by Sai Hertz And Control Systems
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'.

Post by Sai Hertz And Control Systems
Also would not like to set ~/.pgpass

Why not? That's what it's for.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org