Re: Importing the dump file in postgresql-7.4.23

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



saravanan <saravanan.kcse@xxxxxxxxx> 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?

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux