Denis Gasparin <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED])
