Re: [Gnumed-devel] Unable to connect

[Karsten Hilbert]

Hello Peter,

> I am a Ubuntu 14.04 user and am trying to make a database for my General
> Practice in Greece.
> I am not very good with the programming aspects.
> I have not been able to connect to the v19 database locally
> I attatch a log file of me 2nd bootstrapping attempt

Looking at your log it seems you don't have the pg_trgm
extension installed:

> 2014-12-01 20:28:21  DEBUG     gm.bootstrapper 
> (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #233): create extension if 
> not exists pg_trgm with schema pg_catalog
> 2014-12-01 20:28:21  ERROR     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
> 2014-12-01 20:28:21  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::_import_schema() #1482): failed to import 
> [../sql/v18-v19/superuser/v19-install-pg_trgm.sql]

And indeed:

> 2014-12-01 20:28:21  DEBUG     gm.db 
> (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #1858): PG 
> extension: (plpgsql,1.0,"PL/pgSQL procedural language")

Please do:

        sudo apt-get install postgresql-contrib

and redo the bootstrapping.

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