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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
