I'm restoring it as the superuser.
You can try to execute the commands directly from psql.
Denis
Doug McNaught wrote:
> Denis Gasparin <denis@edistar.com> writes:
>
>
>>Looking into the generated sql, i find that the schema is created with
>>the command:
>>
>>CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER;
>>
>>SET SESSION AUTHORIZATION aaa;
>>CREATE SCHEMA aaa;
>>
>>This fails giving me the following error:
>>ERROR: aaaa: permission denied
>>
>>Any ideas?
>
>
> Are you doing the restore as a regular user? Output of pg_dumpall is
> designed to be restored by the superuser.
>
> -Doug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)