=?ISO-8859-1?Q?Lu=EDs_Sousa?= <llsousa@xxxxxxx> 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
