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: 0105A1BF505D304E9E5AF38B63E40E4E69D44E@EXCHANGE.siglercompanies.com (view raw or flat)
Thread:
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:

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

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-2014 The PostgreSQL Global Development Group