X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4863D9FB2B8 for ; Mon, 4 Sep 2006 12:18:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 27285-03 for ; Mon, 4 Sep 2006 15:18:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2ADAE9FB292 for ; Mon, 4 Sep 2006 12:18:24 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k84FINPF024367; Mon, 4 Sep 2006 11:18:23 -0400 (EDT) To: =?ISO-8859-1?Q?Lu=EDs_Sousa?= cc: pgsql-admin Subject: Re: SET SESSION AUTHORIZATION permissions In-reply-to: <44FC0A96.30406@ualg.pt> References: <44FC0A96.30406@ualg.pt> Comments: In-reply-to =?ISO-8859-1?Q?Lu=EDs_Sousa?= message dated "Mon, 04 Sep 2006 12:14:30 +0100" Date: Mon, 04 Sep 2006 11:18:23 -0400 Message-ID: <24366.1157383103@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/22 X-Sequence-Number: 22936 =?ISO-8859-1?Q?Lu=EDs_Sousa?= 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