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(at)sss(dot)pgh(dot)pa(dot)us>
> *Sent:* Tuesday, April 16, 2019 9:45 PM
> *To:* Julie Nishimura
> *Cc:* Adrian Klaver; pgsql-general(at)lists(dot)postgresql(dot)org
> *Subject:* Re: text search configuration missing while migration from
> 8.3 to 9.4
> Julie Nishimura <juliezain(at)hotmail(dot)com> writes:
>> 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?
>
> 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(dot)klaver(at)aklaver(dot)com