From: saravanan <saravanan.kcse@gmail.com>
To: pgsql-admin@postgresql.org
Subject: 'ERROR: Permission denied for schema' while importing dump
Date: Thu, 14 Jul 2011 07:08:12 -0700 (PDT)
Message-ID: <1310652492935-4586749.post@n5.nabble.com> (raw)
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-tp45...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: saravanan.kcse@gmail.com
Subject: Re: 'ERROR: Permission denied for schema' while importing dump
In-Reply-To: <1310652492935-4586749.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox