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?
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? |