Received: from maia.hub.org (unknown [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 02721B5DC3D for ; Thu, 14 Jul 2011 11:30:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 95510-04 for ; Thu, 14 Jul 2011 14:28:09 +0000 (UTC) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by mail.postgresql.org (Postfix) with ESMTP id D789CB5DD68 for ; Thu, 14 Jul 2011 11:08:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mx1.hub.org (Postfix) with ESMTP id 1ADE727FD9B1 for ; Thu, 14 Jul 2011 11:08:13 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QhMaK-0001l1-UT for pgsql-admin@postgresql.org; Thu, 14 Jul 2011 07:08:12 -0700 Date: Thu, 14 Jul 2011 07:08:12 -0700 (PDT) From: saravanan To: pgsql-admin@postgresql.org Message-ID: <1310652492935-4586749.post@n5.nabble.com> Subject: 'ERROR: Permission denied for schema' while importing dump MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.766 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, NO_DNS_FOR_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201107/101 X-Sequence-Number: 37880 Hi all, I'm using PostgreSQL - 8.0.0 version. I tried to importing dumps but i'm getting the following error . Before importing the dumps, i used to install some functions like ltree, tsearch2, pgcrypto from directory /usr/local/src/postgresql-8.0/contrib. So that i can avoid some errors. But i'm getting *ERROR: Permission denied for schema web* this error occurs while creating table. Based on this error, i'm getting more errors. Here dumps were created in a right way using pg_dumpall. I just trying to import the dump. Can anyone help me to crack this error? I don't know which version the dump has been taken, but sure this error were some thing different. It should import the dump as it is. This dump might be taken in PostgreSQL - 7.4.23 version. http://postgresql.1045698.n5.nabble.com/file/n4586749/Schema-Error1.jpg -- View this message in context: http://postgresql.1045698.n5.nabble.com/ERROR-Permission-denied-for-schema-while-importing-dump-tp4586749p4586749.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.