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

On 4/16/19 10:51 PM, Julie Nishimura wrote:
> Thank you. Is there a way to find out if I have tables with tsvectors or 
> indexes? I have hundreds of tables...

I'm afraid I know the answers, but I will ask anyway:

Is there any documentation to go along with the database?

Or, is the schema in some form of version control that you can search?

> 
> ------------------------------------------------------------------------
> *From:* Tom Lane <tgl@sss.pgh.pa.us>
> *Sent:* Tuesday, April 16, 2019 9:45 PM
> *To:* Julie Nishimura
> *Cc:* Adrian Klaver; pgsql-general@lists.postgresql.org
> *Subject:* Re: text search configuration missing while migration from 
> 8.3 to 9.4
> Julie Nishimura <juliezain@hotmail.com> writes:
>> Thank you guys. I've dumped the schema and was able to load it properly this time. There were some missing text
searchdictionaries, fts templates and functions. I was able to recreate it. Now is my question - do I need to reload
thedata?
 
> 
> The base textual data should be fine, but if you've got derived
> tsvector columns or indexes, you might need to recompute those.
> 
>                          regards, tom lane


-- 
Adrian Klaver
adrian.klaver@aklaver.com