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

On 4/16/19 2:46 PM, Tom Lane wrote:
> Julie Nishimura <juliezain(at)hotmail(dot)com> writes:
>> 1) This is the 8.3 source:
>> select * from pg_ts_dict;
>> ...
>> english_stem_nostop | 21960 | 10 | 11282 | language = 'english'
>> hwsplit | 21960 | 10 | 22342 |
>> hwsplit_only | 21960 | 10 | 22342 | returnreplaced = 'false', keeporig = 'false'
>
> OK, so you have some non-built-in text search objects in your 8.3
> installation. That's fine, but the dump/restore process should certainly
> have included commands to recreate those objects in the new database.
> Did you ignore any errors during the dump or restore? (Trying to run
> the restore as a non-superuser could well have led to failure to restore
> these objects, for instance, but you'd have gotten errors.) Did you perhaps
> do a selective dump or restore? (For example, excluding whatever schema
> 21960 is would've led to excluding these objects.)
>
> If you're not real sure about the errors angle, I'd suggest retrying
> the process to see. You could use "pg_dump -s" to dump only schema
> not data, so as to make that faster --- any relevant errors should
> still occur.
>
> I'm a bit confused by the initial report, too. If you are missing
> the text search configuration(s) your application needs, that should
> lead to query errors, not just things running slower. What exactly
> is going wrong?
>
>> Unfortunately, I am not sure about tsearch2,
>
> psql's "\dx" would tell you what extensions are installed in the
> 8.3 database.

Unfortunately that does not exist in 8.3. I think because CREATE
EXTENSION did not appear until 9.1

>
> regards, tom lane
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com