Re: Importing the dump file in postgresql-7.4.23

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