Mike Nolan <nolan@gw.tssi.com> writes:
> I'm restoring a full dump from a 7.3.3 system to a new 7.4.1 system and am
> getting a 'permission denied' error when it tries to create the user
> schemas.
Yeah, this is an error in the 7.3 pg_dump logic for schemas. Use the
pg_dump from the 7.4 installation to dump the 7.3 server, or manually
edit the dump file ...
regards, tom lane