From: chanh.tran@free.fr
To: pgsql-admin@postgresql.org
Subject: Pb migrating database from Postgres 8.1 to 8.4
Date: Fri, 19 Apr 2013 14:58:23 +0200 (CEST)
Message-ID: <1513898572.54354333.1366376303229.JavaMail.root@spooler8-g27.priv.proxad.net> (raw)
In-Reply-To: <384628703.54353818.1366376288469.JavaMail.root@spooler8-g27.priv.proxad.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi all,
I'm facing pbs trying to migrate my current database from Postgres 8.1 to 8.4.
The way I proceed is as 'root' :
su - postgres
createuser -A -R -d -E my_user
createdb --locale C --template template0 --encoding SQL_ASCII my_db
tsearch2_sql='/usr/share/pgsql/contrib/tsearch2.sql'
psql my_db < $tsearch2_sql
pg_restore -d my_db my_db_tar
#######################################
Msgs from during 'restore' :
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 79; 1255 16554 FUNCTION gtsvector_in(cstring) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not find function "gtsvector_in" in file "/usr/lib64/pgsql/tsearch2.so"
Command was: CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
AS '$libdir/tsearch2', 'gtsvector_in'
LANGUAGE c STRICT;
pg_restore: [archiver (db)] could not execute query: ERROR: function public.gtsvector_in(cstring) does not exist
Command was: ALTER FUNCTION public.gtsvector_in(cstring) OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 80; 1255 16555 FUNCTION gtsvector_out(gtsvector) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not find function "gtsvector_out" in file "/usr/lib64/pgsql/tsearch2.so"
Command was: CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring
AS '$libdir/tsearch2', 'gtsvector_out'
LANGUAGE c STRICT;
pg_restore: [archiver (db)] could not execute query: ERROR: function public.gtsvector_out(gtsvector) does not exist
Command was: ALTER FUNCTION public.gtsvector_out(gtsvector) OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 350; 1247 16553 TYPE gtsvector postgres
pg_restore: [archiver (db)] could not execute query: ERROR: function gtsvector_in(cstring) does not exist
Command was: CREATE TYPE gtsvector (
INTERNALLENGTH = variable,
INPUT = gtsvector_in,
OUTPUT = gtsvector_out,
ALIGNMENT =...
pg_restore: [archiver (db)] Error from TOC entry 56; 1255 16527 FUNCTION tsquery_in(cstring) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not find function "tsquery_in" in file "/usr/lib64/pgsql/tsearch2.so"
Command was: CREATE FUNCTION tsquery_in(cstring) RETURNS tsquery
AS '$libdir/tsearch2', 'tsquery_in'
LANGUAGE c STRICT;
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 79; 1255 16554 FUNCTION gtsvector_in(cstring) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not find function "gtsvector_in" in file "/usr/lib64/pgsql/tsearch2.so"
Command was: CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
AS '$libdir/tsearch2', 'gtsvector_in'
LANGUAGE c STRICT;
............
########################################
Thx in advance for any help
Regards
Chanh
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chanh.tran@free.fr
Subject: Re: Pb migrating database from Postgres 8.1 to 8.4
In-Reply-To: <1513898572.54354333.1366376303229.JavaMail.root@spooler8-g27.priv.proxad.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox