is your target DB >=8.x? Did you use to have tsearch2 installed in 7.4? Anyway, this is how we used to dump from 7.4 and load into 8.3: take the dump from 7.4, install 8.3 initdb, etc... cd /usr/local/src/postgresql-8.3.3 cd contrib/tsearch2/ make uninstall cd ../intarray/ make uninstall create domain public.tsvector as pg_catalog.tsvector; create domain public.gtsvector as pg_catalog.gtsvector; create domain public.tsquery as pg_catalog.tsquery; psql yourdb -f yourdb_DUMP_OUR_DUMP_FROM_7_4.sql >2see 2>&1 DROP TABLE public.pg_ts_cfg; DROP TABLE public.pg_ts_cfgmap; DROP TABLE public.pg_ts_dict ; DROP TABLE public.pg_ts_parser ; DROP TYPE public.query_int ; DROP TYPE public.statinfo ; DROP TYPE public.tokenout ; DROP TYPE public.tokentype ; DROP FUNCTION public.ts_debug(text) ; DROP TYPE public.tsdebug ; for every table with fields of tsvector do ALTER TABLE yourtable ALTER idxfti TYPE pg_catalog.tsvector; DROP DOMAIN public.gtsvector ; DROP DOMAIN public.tsquery ; DROP DOMAIN public.tsvector ; cd /usr/local/src/postgresql-8.3.3/contrib/tsearch2 (compatibility package) make install load 'tsearch2'; \i /usr/local/src/postgresql-8.3.3/contrib/tsearch2/tsearch2.sql setup the new tsearch triggers, and you are ready to go! Στις Tuesday 12 July 2011 15:54:38 ο/η saravanan έγραψε: > 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.jpg > > > > > > http://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-tp4578769p4578769.html > Sent from the PostgreSQL - admin mailing list archive at Nabble.com. > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
