You'll want to check out possibly using a pgpass file or changing the authentication method in your pg_hba.conf.
Relevantdoc 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
anestablished %APPDATA% directory. I'd suggest starting with setting trust auth to the apache user for local
connectionsand depending on your security requirements complicating the setup from there.
-----Original Message-----
From: pgsql-php-owner@postgresql.org
[mailto:pgsql-php-owner@postgresql.org]On Behalf Of enzo venegas
palacios
Sent: Monday, September 12, 2005 11:57 AM
To: pgsql-php@postgresql.org
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
