postgres.md

title	description	published	date	tags	editor
DB - PostgreSQL	Search Engine Module	true	2020-06-07 17:15:39 UTC		markdown

This engine makes use of the advanced capabilities of PostgreSQL to provide a "good enough" search solution.

You must be running Wiki.js using a PostgreSQL database in order to use this engine! {.is-warning}

Requirements

The pg_trgm extension must be enabled on the PostgreSQL for this engine to function correctly. It is enabled by default on most installations, but if that's not the case, you can enable it by running:

CREATE EXTENSION pg_trgm;

The extension has to be activated per database so make sure to enable it for your Wiki.js database.{.is-info}

Setup

1. In the Wiki.js administration area, click on Search Engine in the sidebar.
2. Select DB - PostgreSQL as the search engine.
3. Select the dictionary language to use in the dropdown list.
4. Click the Apply button to save and initialize the search engine. An index will be created automatically.

Note that if you already have content in your wiki, you must click on Rebuild Index afterwards to import all your existing content into the search engine. Any change (new, edit, delete page) will be handled automatically from this point forward.