[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Bug in pg_dumpall
From:       Denis Gasparin <denis () edistar ! com>
Date:       2003-11-21 16:06:01
[Download RAW message or body]

I'm restoring it as the superuser.

You can try to execute the commands directly from psql.

Denis

Doug McNaught wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread]