Re: Backup database through web and php

From: Naomi Walker <nwalker(at)eldocomp(dot)com>
To: "Lau NH" <launh(at)perridot(dot)com>, <pgsql-admin(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Backup database through web and php
Date: 2002-01-30 17:31:29
Message-ID: 4.2.2.20020130102837.00aa9890@ecint.ecinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sean Chittenden 2002-01-30 17:56:36 Re: INSERT performace.
Previous Message Oleg Bartunov 2002-01-30 17:21:00 postgresql under Windows is slow

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-30 17:58:04 Re: postgresql under Windows is slow
Previous Message Oleg Bartunov 2002-01-30 17:21:00 postgresql under Windows is slow