Re: Bug in pg_dumpall

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