GRANT SELECT ON bi.met_pest TO fieldsofrussia;
sudo -u postgres psql -c "CREATE DATABASE wikijs;"
sudo -u postgres psql -c \"CREATE USER wikiuser WITH ENCRYPTED PASSWORD 'StrongPasswordHere';\"
sudo -u postgres psql -c "GRANT ALL PRIVILEGES ON DATABASE wikijs TO wikiuser;"
psql -U wikiuser -h localhost -d wikijs
\q
To execute pg_trgm for a PostgreSQL database, the extension must first be enabled within that specific database. enable the pg_trgm extension.
Connect to your PostgreSQL database using a client like psql or pgAdmin and execute the following SQL command:
CREATE EXTENSION pg_trgm;
The extension has to be activated per database so make sure to enable it for your Wiki.js database.