possible pg_dumpall (7.1.3) bug - Mailing list pgsql-hackers

From Thomas Swan
Subject possible pg_dumpall (7.1.3) bug
Date
Msg-id 3C6D45E7.6030302@olemiss.edu
Whole thread Raw
List 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?






pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: "Bug" in statistics for v7.2?
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Ready to branch 7.2/7.3 ?