Postgres 9.6 full text search config needed

Bug #1708510 reported by Bill Erickson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Medium
Unassigned

Bug Description

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

Tags: pullrequest
Bill Erickson (berick)
description: updated
Revision history for this message
Mike Rylander (mrylander) wrote :

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.

Revision history for this message
Bill Erickson (berick) wrote :
tags: added: pullrequest
Changed in evergreen:
status: New → Confirmed
milestone: none → 3.0-alpha
Revision history for this message
Ben Shum (bshum) wrote :

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)
Changed in evergreen:
assignee: nobody → Galen Charlton (gmc)
importance: Wishlist → Medium
Revision history for this message
Galen Charlton (gmc) wrote :

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.

Changed in evergreen:
status: Confirmed → Fix Committed
Galen Charlton (gmc)
Changed in evergreen:
assignee: Galen Charlton (gmc) → nobody
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.