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?





Fri, 15 Feb 2002 11:31:19 -0600
Thomas Swan <tswan@olemiss.edu>
possible pg_dumpall (7.1.3) bug