Hi all,
I am writing a php script to backup my postgres database through web interface, but my database is password required. When I do a pg_dump at the linux shell prompt, it will prompt for password in order to backup the database, does anyone know how to pass this password with the pg_dump command together so that I can do it using php system call?
I was just reading up on this subject, and it suggests using PGPASSWORD in the environment. I have not tried that yet, but think all the passwords must be the same.
It is sometimes unclear to me when challenged for a password, logged in as postgres, whether or not they want the database password I am working on, or postgres'. So far, it appears to be asking for the postgres password.
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242