You'll want to check out possibly using a pgpass file or changing the authentication method in your pg_hba.conf. Relevant doc links are: http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html and http://www.postgresql.org/docs/8.0/interactive/client-authentication.html To get better security, you would probably want to set up another daemon running as a separate user to send a request to (SOAP, etc) for a backup file. But since you mention you are in an intranet situation it may not be as much of a concern. Also, pgpass file can be a little bit tricky on windows, especially since your apache user likely doesn't have an established %APPDATA% directory. I'd suggest starting with setting trust auth to the apache user for local connections and depending on your security requirements complicating the setup from there. -----Original Message----- From: pgsql-php-owner@xxxxxxxxxxxxxx [mailto:pgsql-php-owner@xxxxxxxxxxxxxx]On Behalf Of enzo venegas palacios Sent: Monday, September 12, 2005 11:57 AM To: pgsql-php@xxxxxxxxxxxxxx Subject: [SPAM] - [PHP] pg_dump - Bayesian Filter detected spam Hello, I have postgresql, apache, win2K and php in a intranet I am trying to create a backup with pg_dump ex: pg_dump -i -U nombre_de_usuario -Fc -b -v -f "C:\Archivos de programa\PostgreSQL\8.0\backup.backup" nombre_db And I have to execute it from php with exec from the web page ex: exec ("C:\Archivos de programa\PostgreSQL\8.0.0-rc1\bin>pg_dump -i -U nombre_de_usuario -Fc -b -v -f "C:\Archivos de programa\PostgreSQL\8.0\backup.backup" nombre_db"); My problem is that this code asks for password me and on having executed the command exec it cannot be deposited ex: C:\Archivos de programa\PostgreSQL\8.0.0-rc1\bin>pg_dump -i -U nombre_de_usuario -Fc -b -v -f "C:\Archivos de programa\PostgreSQL\8.0\backup.backup" nombre_db C:\pass:_ There exists some form of which he(she) does not ask for the key me? Treat creating users without key, but it(he,she) gives the same result enzo --------------------------------------------------------- Vuelve el pleno al 15. Juega a la quiniela y hazte millonario en http://sorteos.ya.com Ya.com ADSL 2MB + Llamadas 24 horas: desde 26,95 EUR/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/2mb ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
