You can try to execute the commands directly from psql.
Denis
Doug McNaught wrote:
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])
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings