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