pg_upgrade (Checking for reg* data types)

Поиск
Список
Период
Сортировка
От Gerrit Fouche
Тема pg_upgrade (Checking for reg* data types)
Дата
Msg-id CAJGpXMgPWzGC4UhJW4Q4u5xn6NRzriXcfA80X9MBbVya29yGKw@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_upgrade (Checking for reg* data types)
Re: pg_upgrade (Checking for reg* data types)
Список pgsql-general

Hi All,

I am trying to upgrade Postgresql 11.5 to 12 RC1, OS Centos 6. Running pg_upgrade with --check it fails with "Checking for reg* data types in user tables" The table listed are: pg_ts_dict,pg_ts_parser. Trying to drop the tables I get msg " permission denied: "pg_ts_dict" is a system catalog" I also for same reason can not remove the oids "ALTER TABLE pg_ts_parser set without oids;"

From pg_catalog.pg_extension the following are listed: plpgsql,pg_stat_statements,tablefunc. So the Text search extension is not in use.

This database was upgrade since Postgresql 8.3 by using "pg_dumpall -p 5432 | psql -d postgres -p 5433" and not pg_upgrade.

Regards
Gerrit Fouche

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Possible bug: SQL function parameter in window frame definition
Следующее
От: Imre Samu
Дата:
Сообщение: Re: Redis 16 times faster than Postgres?