This may be with the pg_dumpall script from 7.1.3 but the restoration
died as a result of the owner not being able to create the database it
owned...
Steps to reproduce:
create a user [testuser] with createdb privilege (to create a database
that they own)
create a database testdb using testuser's account
drop the createdb privilege from testuser (so they can't create an more
databases)
add a table to the testdb as testuser
pg_dumpall > dump.pgsql
upgrade to postgresql 7.2
psql -U postgres template1 < dump.pgsql*it dies here*
Can pg_dumpall create the script where user postgres creates the
database and the assigns the owner to another user rather than assuming
the owner can create the database?