Postgres Pro
Downloads
Home   >   mailing lists

Re: SET SESSION AUTHORIZATION permissions - Mailing list pgsql-admin

From Tom Lane
Subject Re: SET SESSION AUTHORIZATION permissions
Date
Msg-id 24366.1157383103@sss.pgh.pa.us
Whole thread Raw
In response to SET SESSION AUTHORIZATION permissions  (Luís Sousa <llsousa@ualg.pt>)
List pgsql-admin
Tree view 
=?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

pgsql-admin by date:

Previous
From: Luís Sousa
Date:
Subject: SET SESSION AUTHORIZATION permissions
Next
From: "Rafaqat Ali"
Date:
Subject: Automating pg-admin