Uh, is there a way around this problem? $ bin/pg_upgrade -c -d /usr/local/pgsql-8.4/data -D data -b /usr/local/pgsql-8.4/bin -B bin Performing Consistency Checks ----------------------------- Checking old data directory (/usr/local/pgsql-8.4/data) ok Checking old bin directory (/usr/local/pgsql-8.4/bin) ok Checking new data directory (data) ok Checking new bin directory (bin) ok Checking for reg* system oid user data types fatal
| Your installation contains one of the reg* data types in | user tables. These data types reference system oids that | are not preserved by pg_upgrade, so this cluster cannot | currently be upgraded. You can remove the problem tables | and restart the migration. A list of the problem columns | is in the file: | /usr/local/pgsql/tables_using_reg.txt $ more tables_using_reg.txt Database: marketticker public.pg_ts_dict.dict_init public.pg_ts_dict.dict_lexize public.pg_ts_parser.prs_start public.pg_ts_parser.prs_nexttoken public.pg_ts_parser.prs_end public.pg_ts_parser.prs_headline public.pg_ts_parser.prs_lextype Database: ticker public.pg_ts_dict.dict_init public.pg_ts_dict.dict_lexize public.pg_ts_parser.prs_start public.pg_ts_parser.prs_nexttoken public.pg_ts_parser.prs_end public.pg_ts_parser.prs_headline public.pg_ts_parser.prs_lextype $ These two databases use the full-text "Tsearch2" module..... I can't remove these tables either; they're marked "system" and even as a superuser removing them is not permitted. Does this mean that I have to dump and restore, and can't use convert? If so that's a real bummer..... -- Karl
<<attachment: karl.vcf>>
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
