Re: Bug in pg_dumpall

I'm restoring it as the superuser.

You can try to execute the commands directly from psql.

Denis

Doug McNaught wrote:
> Denis Gasparin <denis(at)edistar(dot)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(at)postgresql(dot)org)