| Lists: | pgsql-adminpgsql-hackers |
|---|
| From: | "Lau NH" <launh(at)perridot(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Backup database through web and php |
| Date: | 2002-01-29 03:01:58 |
| Message-ID: | 003401c1a871$516922a0$0401230a@perridot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin pgsql-hackers |
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?
| From: | "Radu-Adrian Popescu" <radu(dot)popescu(at)aldratech(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-29 14:14:15 |
| Message-ID: | 001601c1a8cf$662e46d0$0600a8c0@rpopescu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin pgsql-hackers |
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(at)postgresql(dot)org ; pgsql-hackers(at)postgresql(dot)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?
| 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 |
| 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