You could setup pg_hba.conf to allow a backup user to connect to the
database locally via trust authentication. I think you could also use a
.pgpass file.
On Mon, Sep 12, 2005 at 11:56:37AM -0500, enzo venegas palacios wrote:
>
> 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 ?/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
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461