From: Tom Lane <tgl@sss.pgh.pa.us>
To: saravanan <saravanan.kcse@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Importing the dump file in postgresql-7.4.23
Date: Tue, 12 Jul 2011 09:19:36 -0400
Message-ID: <10783.1310476776@sss.pgh.pa.us> (raw)
In-Reply-To: <1310475278308-4578769.post@n5.nabble.com>
References: <1310475278308-4578769.post@n5.nabble.com>
saravanan <saravanan.kcse@gmail.com> writes:
> 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*
Look at the *first* error (which you did not show us). I'm betting it's
something along the line of a missing library file, eg contrib/tsearch2
not available. A missing datatype would cascade to table creation
failures, and then to COPY commands failing. The stuff you did show us
looks like the detritus from failed COPY commands.
regards, tom lane
PS: You do know that 7.4.x was obsoleted some time ago, no?
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: tgl@sss.pgh.pa.us, saravanan.kcse@gmail.com
Subject: Re: Importing the dump file in postgresql-7.4.23
In-Reply-To: <10783.1310476776@sss.pgh.pa.us>
* 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