Suggest edits


Implementing Chemaxon JChem PostgreSQL Cartridge with EDB Postgres Advanced Server requires the following components:

  • A running EDB Postgres Advanced Server instance
  • Java 11 runtime environment

You must request an EDB-compatible version of JChem PostgreSQL Cartridge from Chemaxon, as EDB requires separate installation packaging.

Configure Chemaxon JChem PostgreSQL Cartridge for EDB Postgres Advanced Server

To install and configure Chemaxon JChem PostgreSQL Cartridge:

  1. Download the latest version of Chemaxon JChem PostgreSQL Cartridge.

  2. Install Chemaxon JChem Postgres Cartridge using the following command on CentOS7:

yum localinstall jchem-psql-edb-x.y.x86_64.rpm
  1. Copy a valid Chemaxon license to /etc/chemaxon/license.cxl:
mv /home/edb/Desktop/license.cxl /etc/chemaxon/

[root@localhost ~]# ls -lrt /etc/chemaxon/
total 12
-rw-rw-r--. 1 root root 1041 Jun 21  2021 jpc-log4j.xml
-rw-rw-r--. 1 root root 2533 Jun 21  2021 jchem-psql.conf
drwxr-xr-x. 2 root root   25 Feb  1 04:27 types
-rw-r--r--. 1 edb  edb   805 Feb  1 04:34 license.cxl
[root@localhost ~]#
  1. Initialize the index directory:
service jchem-psql init
  1. Start the service:
service jchem-psql manual-start
  1. Log in to your EDB Postgres Advanced Server instance and create the following extensions:
CREATE EXTENSION chemaxon_type;
         CREATE EXTENSION hstore;
         CREATE EXTENSION chemaxon_framework;
  1. On your EDB Postgres Advanced Server instance, verify that the jchem-psql service is running:
edb=# SELECT 'C'::Molecule('sample') |<| 'CC'::Molecule;
           (1 row)


Could this page be better? Report a problem or suggest an addition!