| From: | Gerrit Fouche <gerrit(dot)fouche(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_upgrade (Checking for reg* data types) |
| Date: | 2019-09-30 09:15:47 |
| Message-ID: | CAJGpXMgPWzGC4UhJW4Q4u5xn6NRzriXcfA80X9MBbVya29yGKw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Imre Samu | 2019-09-30 09:40:31 | Re: Redis 16 times faster than Postgres? |
| Previous Message | Andrew Gierth | 2019-09-30 05:37:48 | Re: Possible bug: SQL function parameter in window frame definition |