=?ISO-8859-1?Q?Lu=EDs_Sousa?= <llsousa@ualg.pt> writes:
> Only superuser can issue the command SET SESSION AUTHORIZATION?
Well, yeah.
> When I tried to dump and the restore on command line with my user, is
> issued a SET SESSION AUTHORIZATION with a permission denied error!
Use --no-owner if you want to make pg_dump output that won't generate
this error (and want all the restored objects to be owned by whoever
runs the script). Or just ignore the error messages.
regards, tom lane