pg_dumpall

The pg_dumpall script is not compatible with 7.0 psql and createdb.

1. pgsql -l delivers a different output (Owner instead of User ID).
Therefore in the following command "usesysid" has to be replaced by
"usename":

POSTGRES_USER="`echo \" \
select usename \
from pg_shadow \
where usesysid = $DBUSERID; \" | \
psql -A -q -t template1`"

2. createdb -help in the following line tries to connect the host "elp".

if createdb -help|grep encoding >/dev/null
then
echo "create database $DATABASE with encoding='`pg_encoding $ENCODING`';"
else
echo "create database $DATABASE;"
fi

Unfortunately it is not sufficient to use

createdb --help|grep encoding

because the word "encoding" is always present in the usage message now.

3. QNX4 only: The double quotes in

POSTGRES_USER="`echo \" \

etc. must not be escaped with a backslash. Unfortunately I haven't found a
simple solution working on all platforms. Thats why I am not sending a
patch.

Andreas Kardos