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
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
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
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.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
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