possible pg_dumpall (7.1.3) bug

From: Thomas Swan <tswan(at)olemiss(dot)edu>
To: Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: possible pg_dumpall (7.1.3) bug
Date: 2002-02-15 17:31:19
Message-ID: 3C6D45E7.6030302@olemiss.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2002-02-15 17:34:27 Re: Ready to branch 7.2/7.3 ?
Previous Message Zeugswetter Andreas SB SD 2002-02-15 17:18:35 Re: "Bug" in statistics for v7.2?