Re: [SPAM] - pg_dump - Bayesian Filter detected spam

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(at)postgresql(dot)org
[mailto:pgsql-php-owner(at)postgresql(dot)org]On Behalf Of enzo venegas
palacios
Sent: Monday, September 12, 2005 11:57 AM
To: pgsql-php(at)postgresql(dot)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