Re: Backup database through web and php

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
Thread:
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?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Zhang, Anna 2002-01-29 15:57:01 tuning SQL
Previous Message Ferdinand Smit 2002-01-29 09:11:46 Re: INSERT performace.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-29 15:05:55 Re: Improving backend launch time by preloading relcache
Previous Message Hannu Krosing 2002-01-29 13:17:19 Re: sequence indexes