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