From: saravanan <saravanan.kcse@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Importing the dump file in postgresql-7.4.23
Date: Fri, 15 Jul 2011 00:11:48 -0700 (PDT)
Message-ID: <1310713908483-4589674.post@n5.nabble.com> (raw)
In-Reply-To: <10783.1310476776@sss.pgh.pa.us>
References: <1310475278308-4578769.post@n5.nabble.com>
<10783.1310476776@sss.pgh.pa.us>
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-tp4578769p45896...
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: Importing the dump file in postgresql-7.4.23
In-Reply-To: <1310713908483-4589674.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