Dear all, I am stuck with database backup. While using pg_dump the utility asks for password but since I require this process to be automated the password prompt is giving me headaches is their any way by which can pass the password automatically. Like setting up a variable in php which passes the password to the pg_dump utility on prompt this way the whole process of pg_dump would get automated. One obvious solution was to use .pgpass but it does not appeal me because it is again a security threat. any pointers or help may lead to unlocked secret. -- With Best Regards, Vishal Kashyap. Lead Software Developer, http://saihertz.com, http://vishalkashyap.tk