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@xxxxxxxxxxx
<mailto: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!
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
