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

From Adrian Klaver
Subject Re: text search configuration missing while migration from 8.3 to 9.4
Date
Msg-id 655674ac-6ecf-17d0-b789-90b1226a3021@aklaver.com
Whole thread Raw
In response to Re: text search configuration missing while migration from 8.3 to 9.4  (Julie Nishimura <juliezain@hotmail.com>)
List pgsql-general
On 4/16/19 4:22 PM, Julie Nishimura wrote:
> Adrian, Hitwise is the name of our company. Unfortunately, it does not 
> 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...
> 

To add to my previous post, you might try Tom's suggestion of just 
dumping the schema from the 8.3 database and restoring that to a 9.4 
database(FYI 9.4 will be the next version to go EOL, so it might be 
prudent to upgrade to a more recent version). Then you could load data 
into the staging tables and see what happens.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

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