|
Thank you guys. I've dumped the schema and was able to load it properly this time. There were some missing text search dictionaries, fts templates and functions. I was able to recreate it. Now is my question - do I need to reload the data?
Thanks!
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Sent: Tuesday, April 16, 2019 5:14 PM To: Julie Nishimura; pgsql-general@xxxxxxxxxxxxxxxxxxxx Subject: Re: text search configuration missing while migration from 8.3 to 9.4 On 4/16/19 4:22 PM, Julie Nishimura wrote:
> Adrian, Hitwise is the name of our company. Unfortunately, it does not Aah that would explain it. > help to find how I can migrate missing search config or install whatever > is on 8.3. I did not restore the entire database (due to its large > size), I've dumped and restored just about 200 hundred tables they > needed on staging. Perhaps, some functions need to be migrated as well, > just do not know where to look... I would start by looking at the queries that where running slowly and see what they where calling. Also in the 8.3 database using psql: \df if you want more info: \df+ That will list the functions installed in the database. It will be a long list. You can reduce by using a pattern. For more info see: https://www.postgresql.org/docs/8.3/app-psql.html > > ------------------------------------------------------------------------ > *From:* Adrian Klaver <adrian.klaver@xxxxxxxxxxx> > *Sent:* Tuesday, April 16, 2019 3:08 PM > *To:* Julie Nishimura; pgsql-general@xxxxxxxxxxxxxxxxxxxx > *Subject:* Re: text search configuration missing while migration from > 8.3 to 9.4 > On 4/16/19 1:55 PM, Julie Nishimura wrote: >> Oh thank you for answering me!!! >> > >> >> Another thing: >> source (8.3): >> >> \dF >> List of text search configurations >> Schema | Name | Description >> ------------+------------+------------------------------------------------ >> pg_catalog | danish | configuration for danish language >> pg_catalog | dutch | configuration for dutch language >> pg_catalog | english | configuration for english language >> pg_catalog | finnish | configuration for finnish language >> pg_catalog | french | configuration for french language >> pg_catalog | german | configuration for german language >> pg_catalog | hungarian | configuration for hungarian language >> pg_catalog | italian | configuration for italian language >> pg_catalog | norwegian | configuration for norwegian language >> pg_catalog | portuguese | configuration for portuguese language >> pg_catalog | romanian | configuration for romanian language >> pg_catalog | russian | configuration for russian language >> pg_catalog | simple | simple configuration >> pg_catalog | spanish | configuration for spanish language >> pg_catalog | swedish | configuration for swedish language >> pg_catalog | turkish | configuration for turkish language >> public | hw_english | Hitwise configuration for the English language >> (17 rows) >> > > > The only thing I can find searching that might be relevant is: > > https://en.wikipedia.org/wiki/Hitwise > > Does that ring any bells? > >> So, the last record "hw_english" does not show in the target. >> >> This is the parameter in postgresql file, same on both locations. >> # default configuration for text search >> default_text_search_config = 'pg_catalog.english' >> >> Unfortunately, I am not sure about tsearch2, it is new system that I >> inherited not too long ago. So, the production is still on 8.3, but >> dev/staging that was built recently, is on 9.4. The engineer who >> installed it said he used it from Puppet module for postgresql... He is >> not sure about tsearch2 module either. Do you know how can I find it? Or >> how can I install it? It seems like some gin indices are missing. I need >> to find out what is missing... >> >> THANK YOU for your help >> > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx -- Adrian Klaver adrian.klaver@xxxxxxxxxxx |
