Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 56AAF9FB269 for ; Mon, 15 Jan 2007 00:18:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 57548-05 for ; Mon, 15 Jan 2007 00:18:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id AD2FB9FB228 for ; Mon, 15 Jan 2007 00:18:28 -0400 (AST) Received: (qmail 26137 invoked by uid 540); 15 Jan 2007 04:11:00 -0000 Received: from 83.143.210.69 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:0(83.143.210.69):SA:0(-2.6/8.0):. Processed in 5.393093 secs); 15 Jan 2007 04:11:00 -0000 Received: from host69-83-143-210.limes.com.pl (HELO ?10.0.1.69?) (informatyka-adamr@83.143.210.69) by ns1.peker.com.pl with SMTP; 15 Jan 2007 04:10:54 -0000 Message-ID: <45AAFFDF.2030206@informatyka.gdansk.pl> Date: Mon, 15 Jan 2007 05:15:27 +0100 From: =?ISO-8859-2?Q?Adam_Rad=B3owski?= User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: =?ISO-8859-2?Q?=22S=E9guier=2C_G=E9raldine=22?= CC: pgsql-admin@postgresql.org Subject: Re: Pg_dump postgreSQL 8.1.3-1 and win2k References: <746EFBA80FE09B41926B64E015DEABE9010B839D@SISA-EXCHCLU.toulouse.spotimage.int> In-Reply-To: <746EFBA80FE09B41926B64E015DEABE9010B839D@SISA-EXCHCLU.toulouse.spotimage.int> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/115 X-Sequence-Number: 24271 I had this same problem on Win2003, but I resolved it in short way, without analysis of problem - I make dumps as owner of database. I suppose, there is a problem with full access to system tables with "no owner" privilleges to dumped database. I think it could be problem on all supported platforms, but when I saw it on Win (one server), I make on other servers (Linux) dumps as owner without testing, if I can to do it as normally privilleged user. Brgds Adam Séguier, Géraldine napisa³(a): > I'm trying to dump a schema and I receive this error : > pg_dump: Error message from server: ERROR: permission denied for > relation pg_ts_dict > > pg_dump: The command was: LOCK TABLE public.pg_ts_dict IN ACCESS SHARE MODE > pg_dump: *** aborted because of error > > The schema was created by a superuser "X", and the dump has been done by another user "Y" which has the privileges : ALL on this table. > > grant ALL on table pg_ts_dict to Y; > > The owner of pg_ts_dict is "X". > > > > Thanks for your answer, > >