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@aklaver.com>
> *Sent:* Tuesday, April 16, 2019 3:08 PM
> *To:* Julie Nishimura; pgsql-general@lists.postgresql.org
> *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@aklaver.com


-- 
Adrian Klaver
adrian.klaver@aklaver.com