Postgres 9.6 full text search config needed

[Bill Erickson]

Building a new database on PG 9.6 yields the following warning:

********************************************************************
There is no configuration for full text search config, for the database
version you have installed (96). If you're not really sure why, you should probably press 'Control-C' now, and abort. To continue using the latest available version (95), press enter. For assistance, please email
<email address hidden> or join #Evergreen on the
freenode IRC network.
*********************************************************************

I confirmed the following prevents the warning. Confirmation this is all that's needed appreciated.

cd /home/opensrf/Evergreen/Open-ILS/src/sql/Pg
ln -s 000.english.pg91.fts-config.sql 000.english.pg96.fts-config.sql

[Mike Rylander (mrylander)]

That's affirmative, ghost rider. That will work fine.

I'll note, though, that we're being a little heavy handed in the DO block of that file. Some languages may not use the snowball stemmer, now or in the future. That's a tomorrow problem to potentially look into, though.

[Bill Erickson (berick)]

Thanks, Mike.

The pattern is full:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/berick/lp1708510-pg-96-full-text-config

[Ben Shum (bshum)]

Fwiw, Debian 9 Stretch ships with PG 9.6 by default, so we had to add the symlink for new DB setup in my working branches as part of bug 1708048 too (https://bugs.launchpad.net/evergreen/+bug/1708048)

Minor conflict cleanup if we merge this first.

[Galen Charlton (gmc)]

This does the thing, so I've pushed it to master. Thanks, Bill! (And Ben, I owe you a Coke).

While I haven't backported it, I note that it would be plausible to do so, particular if we decide to backport Stretch support to rel_2_12.