From: saravanan <saravanan.kcse@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Importing the dump file in postgresql-7.4.23
Date: Tue, 12 Jul 2011 05:54:38 -0700 (PDT)
Message-ID: <1310475278308-4578769.post@n5.nabble.com> (raw)
Hi all,
I'm using PostgreSQL-7.4.23 version. I have one dump file that was taken
using pg_dumpall utility. Now i tried to import the dump file. But its
throwing me lot of *Invalid Command \N error* , *ERROR: type tsvector does
not exist* and *\t: extra argument "string" ignored error*
I'm using 7.4.23 psql tool to import
I tried the following ways to import pg_dumpall dump file
psql -f all.dump template1
psql -e template1 < all.dump
Here some of DDL commands were imported correctly. Commands like copy were
not imported properly, its throwing lot of "Invalid Command \N error".
Can anyone help me out of this problem?
Here are the some images while importing dump file
http://postgresql.1045698.n5.nabble.com/file/n4578769/1.jpghttp://postgresql.1045698.n5.nabble.com/file/n4578769/2.jpg
Any help would be appreciated
Advance
Thanks
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Importing-the-dump-file-in-postgresql-7-4-23-tp4578769p45787...
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: <1310475278308-4578769.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