Hi all,
   I am writing a php script to backup my postgres database through web interface, but my database is password required.  When I do a pg_dump at the linux shell prompt, it will prompt for password in order to backup the database, does anyone know how to pass this password with the pg_dump command together so that I can do it using php system call?  








Hi all,
   I am writing a php script to backup my 
postgres database through web interface, but my database is password 
required.  When I do a pg_dump at the linux shell prompt, it will prompt 
for password in order to backup the database, does anyone know how to pass this 
password with the pg_dump command together so that I can do it using php system 
call?
Tue, 29 Jan 2002 11:01:58 +0800
"Lau NH" <launh@perridot.com>
Backup database through web and php
You could set the authentification method to "trust" for the host the script is being run from, so you won't get a password prompt at all (see the pg_hba.conf file).

----- Original Message ----- 
  From: Lau NH 
  To: pgsql-admin@postgresql.org ; pgsql-hackers@postgresql.org 
  Sent: Tuesday, January 29, 2002 05:01
  Subject: [ADMIN] Backup database through web and php


  Hi all,
     I am writing a php script to backup my postgres database through web interface, but my database is password required.  When I do a pg_dump at the linux shell prompt, it will prompt for password in order to backup the database, does anyone know how to pass this password with the pg_dump command together so that I can do it using php system call?  








You could set the authentification 
method to "trust" for the host the script is being run from, so you 
won't get a password prompt at all (see the pg_hba.conf file).
 
----- Original Message ----- 

From:
Lau NH 
To: pgsql-admin@postgresql.org ; pgsql-hackers@postgresql.org

Sent: Tuesday, January 29, 2002 
  05:01
Subject: [ADMIN] Backup database through 
  web and php

Hi all,
   I am writing a php script to backup 
  my postgres database through web interface, but my database is password 
  required.  When I do a pg_dump at the linux shell prompt, it will prompt 
  for password in order to backup the database, does anyone know how to pass 
  this password with the pg_dump command together so that I can do it using php 
  system call?
Tue, 29 Jan 2002 16:14:15 +0200
"Radu-Adrian Popescu" <radu.popescu@aldratech.com>
Re: Backup database through web and php
At 11:01 AM 1/29/02 +0800, Lau NH wrote:
>Hi all,
>    I am writing a php script to backup my postgres database through web 
> interface, but my database is password required.  When I do a pg_dump at 
> the linux shell prompt, it will prompt for password in order to backup 
> the database, does anyone know how to pass this password with the pg_dump 
> command together so that I can do it using php system call?
>
I was just reading up on this subject, and it suggests using PGPASSWORD in 
the environment.  I have not tried that yet, but think all the passwords 
must be the same.

It is sometimes unclear to me when challenged for a password, logged in as 
postgres, whether or not they want the database password I am working on, 
or postgres'.  So far, it appears to be asking for the postgres password.
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242 

At 11:01 AM 1/29/02 +0800, Lau NH wrote:
Hi all,
   I am writing a php script to backup my postgres database
through web interface, but my database is password required.  When I
do a pg_dump at the linux shell prompt, it will prompt for password in
order to backup the database, does anyone know how to pass this password
with the pg_dump command together so that I can do it using php system
call?  
 I was just reading up on this subject, and it suggests
using PGPASSWORD in the environment.  I have not tried that yet, but
think all the passwords must be the same.  

It is sometimes unclear to me when challenged for a password, logged in
as postgres, whether or not they want the database password I am working
on, or postgres'.  So far, it appears to be asking for the postgres
password.
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242
Wed, 30 Jan 2002 10:31:29 -0700
Naomi Walker <nwalker@eldocomp.com>
Re: Backup database through web and php