Larry Rosenman <[EMAIL PROTECTED]> writes: > When I try and RESTORE a pg_dump in the current state, we get errors because > the public schema is owned by postgres, and the grant commands are issued > as the user (since I'm restoring as the purported owner.
That's a different issue entirely, which is that if you want to restore a dump containing objects of multiple ownerships, you need to be superuser; else you can't "give away" the ownership. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate