From: | Karl Denninger <karl(at)denninger(dot)net> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem with pg_convert from 8.4 -> 9.0 |
Date: | 2010-09-22 02:44:36 |
Message-ID: | 4C996D94.8000103@denninger.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Content-Type | Size |
---|---|---|
karl.vcf | text/x-vcard | 180 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Gorge A. Marges | 2010-09-22 03:10:51 | Re: Reclaiming space |
Previous Message | Bryan Murphy | 2010-09-22 02:06:42 | Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working |