Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 7475CB5DC60 for ; Fri, 15 Jul 2011 04:11:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 28522-04 for ; Fri, 15 Jul 2011 07:11:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id E2738B5DC53 for ; Fri, 15 Jul 2011 04:11:48 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QhcYu-0005zC-Fr for pgsql-admin@postgresql.org; Fri, 15 Jul 2011 00:11:48 -0700 Date: Fri, 15 Jul 2011 00:11:48 -0700 (PDT) From: saravanan To: pgsql-admin@postgresql.org Message-ID: <1310713908483-4589674.post@n5.nabble.com> In-Reply-To: <10783.1310476776@sss.pgh.pa.us> References: <1310475278308-4578769.post@n5.nabble.com> <10783.1310476776@sss.pgh.pa.us> Subject: Re: Importing the dump file in postgresql-7.4.23 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.767 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201107/105 X-Sequence-Number: 37884 Hi, I tried to troubleshoot the errors while importing dumps in PostgreSQL - 8.0.0 version. But still i'm getting some permission level errors. 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. Here is the first which i got *ERROR: Permission denied for schema web* this error occurs while creating table. Based on this error, i'm getting more errors. Here is the command i used to import psql -e template1 < sdcvb.dump. I'm moving dumps from one version to another version. How can i solve this error? can anyone help me to crack this error? Note: i have dump file only. i can't take another dump from db. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Importing-the-dump-file-in-postgresql-7-4-23-tp4578769p4589674.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.