text search configuration missing while migration from 8.3 to 9.4

From: Julie Nishimura <juliezain(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: text search configuration missing while migration from 8.3 to 9.4
Date: 2019-04-16 17:32:35
Message-ID: BYAPR08MB5014F61156E4F828C478DF39AC240@BYAPR08MB5014.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julie Nishimura 2019-04-16 19:02:58 Re: text search configuration missing while migration from 8.3 to 9.4
Previous Message Adrian Klaver 2019-04-16 17:23:29 Re: Possible corrupt index?