| 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: | Re: text search configuration missing while migration from 8.3 to 9.4 |
| Date: | 2019-04-16 19:02:58 |
| Message-ID: | BYAPR08MB501459E049FCFA6CABB88CACAC240@BYAPR08MB5014.namprd08.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)hotmail(dot)com<mailto:juliezain(at)hotmail(dot)com>> 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-04-16 20:02:05 | Re: text search configuration missing while migration from 8.3 to 9.4 |
| Previous Message | Julie Nishimura | 2019-04-16 17:32:35 | text search configuration missing while migration from 8.3 to 9.4 |