X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ECEB5D946C for ; Tue, 4 Oct 2005 19:22:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03417-03 for ; Tue, 4 Oct 2005 22:22:50 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 51CEFDA0E8 for ; Tue, 4 Oct 2005 19:22:51 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id A1B1E1527C; Tue, 4 Oct 2005 17:22:54 -0500 (CDT) Date: Tue, 4 Oct 2005 17:22:54 -0500 From: "Jim C. Nasby" To: enzo venegas palacios Cc: "pgsql-php@postgresql.org" Subject: Re: pg_dump Message-ID: <20051004222254.GL40138@pervasive.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 required=5 tests=[AWL=0.008] X-Spam-Level: X-Archive-Number: 200510/7 X-Sequence-Number: 3275 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