Pb migrating database from Postgres 8.1 to 8.4

Поиск
Список
Период
Сортировка
От chanh.tran@free.fr
Тема Pb migrating database from Postgres 8.1 to 8.4
Дата
Msg-id 1513898572.54354333.1366376303229.JavaMail.root@spooler8-g27.priv.proxad.net
обсуждение исходный текст
Ответы Re: Pb migrating database from Postgres 8.1 to 8.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Bert
Дата:
Сообщение: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Следующее
От: "Rajiv Kasera"
Дата:
Сообщение: Re: Upgrade from 8.4