pg_dump

Hi Guys,

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?

The problem is that the script itself will be running as the 'www' user, so
it's also not possible to use a .pgpass file.

What on earth can I do?

Chris

On 20 May 2003 at 12:24, Christopher Kings-Lynne wrote:

> I believe it doesn't respect the PGPASS variable anymore, so what do I do?
>
> The problem is that the script itself will be running as the 'www' user, so
> it's also not possible to use a .pgpass file.

Will ident authentication and a read-all access for a www database user would
help?

HTH

Bye
Shridhar

--
Worst Month of 1981 for Downhill Skiing: August. The lift lines are the
shortest, though. -- Steve Rubenstein

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/