To: saravanan <saravanan.kcse@gmail.com>
cc: pgsql-admin@postgresql.org
Subject: Re: Importing the dump file in postgresql-7.4.23 
In-reply-to: <1310475278308-4578769.post@n5.nabble.com> 
References: <1310475278308-4578769.post@n5.nabble.com>
Comments: In-reply-to saravanan <saravanan.kcse@gmail.com>
	message dated "Tue, 12 Jul 2011 05:54:38 -0700"
Date: Tue, 12 Jul 2011 09:19:36 -0400
Message-ID: <10783.1310476776@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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?