Re: text search configuration missing while migration from 8.3 to 9.4

[Julie Nishimura <juliezain@xxxxxxxxxxx>]

Correction: tables are not missing, but some records from the tables missing. How can we migrate them properly from 8.3 to 9.4?

Sent from my iPhone

On Apr 16, 2019, at 10:32 AM, Julie Nishimura <juliezain@xxxxxxxxxxx> wrote:

Hello, we recenlty created fresh install of 9.4, created new dbs, and pg_dumped and restored correspondent dbs from 8.3 (pg_dump|psql, being on target). Now we've noticed that some of `pg_catalog.pg_ts_config` and pg_ts_dict tables are missing, making text search on 9.4 very slow. We tried to insert missing records from pg_catalog.pg_ts_config, but it does not help. What is the proper procedure for it? Please help, thanks!