Re: [Gnumed-bugs] Problem bootstrapping database for new installation (version 1.5.9)

[Karsten Hilbert]

Hello Jorge,

your problem is easy to fix. The log says that the PostgreSQL
extension pg_trgm cannot be accessed (it is used to speed up
access to patient name based queries):

        gm.bootstrapper (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() 
#233): create extension if not exists pg_trgm with schema pg_catalog
        gm.bootstrapper (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() 
#238): ../sql/v18-v19/superuser/v19-install-pg_trgm.sql:11: could not open 
extension control file "/usr/share/postgresql/9.3/extension/pg_trgm.control": 
No such file or directory

And sure enough it is not installed:

        gm.db (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() 
#1933): PG option [zero_damaged_pages]: off
        gm.db (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() 
#1945): PG extension: (plpgsql,1.0,"PL/pgSQL procedural language")
        gm.bootstrapper (./bootstrap_gm_db_system.py::__bootstrap() #608): 
creating database-specific authentication group role

So, installing that should make bootstrapping work.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346