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

On 4/16/19 12:02 PM, Julie Nishimura wrote:
> Correction: tables are not missing, but some records from the tables 
> missing. How can we migrate them properly from 8.3 to 9.4?

This is going to need some more info:

1) What records?

2) 8.3 was the version where text search was integrated into core. Where 
you using tsearch2 before you moved to 8.3?

3) If the answer to 2) is yes, did you have the contrib/tsearch2  module 
installed in 8.3 for backwards compatibility?

4) How was the 9.4 version installed?

4) If the answer to 3) is yes did you install the contrib/tsearch2 in 
the 9.4 cluster?

> 
> Sent from my iPhone
> 
> On Apr 16, 2019, at 10:32 AM, Julie Nishimura <juliezain@hotmail.com 
> <mailto: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!


-- 
Adrian Klaver
adrian.klaver@aklaver.com