Postgres Pro
Downloads
Home   >   mailing lists

Re: text search configuration missing while migration from 8.3 to 9.4 - Mailing list pgsql-general

From Julie Nishimura
Subject Re: text search configuration missing while migration from 8.3 to 9.4
Date
Msg-id BYAPR08MB501459E049FCFA6CABB88CACAC240@BYAPR08MB5014.namprd08.prod.outlook.com
Whole thread Raw
In response to text search configuration missing while migration from 8.3 to 9.4  (Julie Nishimura <juliezain@hotmail.com>)
Responses Re: text search configuration missing while migration from 8.3 to 9.4  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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@hotmail.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!

pgsql-general by date:

Previous
From: Julie Nishimura
Date:
Subject: text search configuration missing while migration from 8.3 to 9.4
Next
From: Adrian Klaver
Date:
Subject: Re: text search configuration missing while migration from 8.3 to 9.4