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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org