Skip site navigation (1) Skip section navigation (2)

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

From: "Jason Minion" <jason(dot)minion(at)sigler(dot)com>
To: <enzovenegas(at)mixmail(dot)com>, <pgsql-php(at)postgresql(dot)org>
Subject: Re: [SPAM] - pg_dump - Bayesian Filter detected spam
Date: 2005-09-12 17:13:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-php
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:

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
Sent: Monday, September 12, 2005 11:57 AM
To: pgsql-php(at)postgresql(dot)org
Subject: [SPAM] - [PHP] pg_dump - Bayesian Filter detected spam


I have postgresql, apache, win2K and php in a intranet
I am trying to create a backup with pg_dump

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

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

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

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

Vuelve el pleno al 15. Juega a la quiniela y hazte millonario en ADSL 2MB + Llamadas 24 horas: desde 26,95 EUR/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

pgsql-php by date

Next:From: Alban Medici (NetCentrex)Date: 2005-09-13 07:58:41
Subject: Re: Getting list of Indexes & contrains
Previous:From: enzo venegas palaciosDate: 2005-09-12 16:56:37
Subject: pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group