| 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: | Whole Thread | Raw Message | 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? |