From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: Importing the dump file in postgresql-7.4.23
Date: Tue, 12 Jul 2011 16:13:27 +0300
User-Agent: KMail/1.9.7
References: <1310475278308-4578769.post@n5.nabble.com>
In-Reply-To: <1310475278308-4578769.post@n5.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201107121613.27356.achill@matrix.gatewaynet.com>

is your target DB >=3D8.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=20

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!

=CE=A3=CF=84=CE=B9=CF=82 Tuesday 12 July 2011 15:54:38 =CE=BF/=CE=B7 sarava=
nan =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hi all,
>=20
> 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 do=
es
> not exist* and *\t: extra argument "string" ignored error*
>=20
> 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
>=20
> Here some of DDL commands were imported correctly. Commands like copy were
> not imported properly, its throwing lot of "Invalid Command \N error".
>=20
>=20
> Can anyone help me out of this problem?
>=20
> Here are the some images while importing dump file=20
> http://postgresql.1045698.n5.nabble.com/file/n4578769/1.jpg=20
>=20
>=20
>=20
>=20
>=20
> http://postgresql.1045698.n5.nabble.com/file/n4578769/2.jpg=20
>=20
>=20
>=20
> Any help would be appreciated
> Advance=20
> Thanks
>=20
>=20
>=20
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Imp=
orting-the-dump-file-in-postgresql-7-4-23-tp4578769p4578769.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>=20


=2D-=20
Achilleas Mantzios