possible pg_dumpall (7.1.3) bug
Thomas Swan <tswan@olemiss.edu>
From: Thomas Swan <tswan@olemiss.edu>
To: Postgresql Hackers <pgsql-hackers@postgresql.org>
Date: 2002-02-15T17:31:19Z
Lists: pgsql-hackers
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?