Re: pg_dump

Hi,

with PostgreSQL you can do it using the environment variables PGUSER and
PGPASSWORD for example in a shellscript like this (bash-syntax):

#!/bin/bash
export PGUSER=customer
export PGPASSWORD=sdds9087c
pg_dump mybigdatabase

or all in one line (eg as content of a system command in PHP):

PGUSER=customer PGPASSWORD=sdds9087c pg_dump mybigdatabase

mfg Frank Finner


On Wed, 16 Jul 2003 11:48:29 +0300 "Viorel Dragomir" <bigchief@vio.ro>
sat down, thought long and then wrote:

> Is there a way to dump all database contents using pg_dump for a
> custom user. Something like:
> pg_dump --user=user_name --password=password database
> where user_name is any user granted to access this database with all
> the rights.
>
> The problem is pg_dump has an option --password, but it's interactive
> and i need to launch the command from a php script.
>
> thx.
>
> Note that mysqldump has this kind of options.

Maybe, but a lot of other options are missing in that database engine.