Re: pg_dump

Christopher Kings-Lynne wrote:
> I'm working on trying to get phpPgAdmin to stream the output of pg_dump to
> the user.
>
> However, it's impossible to set the password!
>
> I believe it doesn't respect the PGPASS variable anymore, so what do I do?

I think the variable is called PGPASSWORD. Example backup script bellow:

#!/bin/sh

umask 0177

PATH="/bin:/sbin:/usr/bin:/usr/sbin"

TODAY=$(date +%a)
DUMPDIR="/backup/"

echo "DB backup start: `date`"

# Do not suck all CPU time...
renice 20 $$

DATA="pgsql"
PGSQL="/usr/local/pgsql/bin/psql"
PGDUMP="/usr/local/pgsql/bin/pg_dump"
PGUSER="pgsql"
PGPASSWORD="blahblah"
export PGUSER PGPASSWORD

DBTYPE="postgres"
OUT="${DUMPDIR}/${TODAY}/${DBTYPE}"
[ -d ${OUT} ] || mkdir -p ${OUT}

DBS=$($PGSQL -tq -d template1 -c "select datname from pg_database" | \
grep -v template)

for DB in $DBS
do
echo "Dumping postgres db: $DB"
$PGDUMP -D $DB -Z 5 -f $OUT/${DB}.sql.gz
done

--
Georgi Chorbadzhiyski
http://georgi.unixsol.org/