Setup ZINC22 database on Server

Initiate Postgres database

Requirements

- Root privilege

Install Python

$ sh /nfs/home/chinzo/code/installation-utilities/install-python36.sh

Install PostgreSQL 12

Please replace [/local2]. This is your postgres data directory. In this case script will create a data directory in this directory.

For example: /local2/psql/12/data

$ sh /nfs/home/chinzo/code/installation-utilities/install-postgres12.sh [/local2]

Install RDKIT Cartridge

You need to specify rdkit and python directory.

/opt/rdkit is directory that you are willing to install rdkit

/opt/python/3.6.7 is directory that you have already installed it

$ /nfs/home/khtang/code/TIN_Scripts/TIN_setup/install_rdkit.sh [/opt/rdkit] [/opt/python/3.6.7]

PostgreSQL12 configuration for TIN

$ sh /nfs/home/chinzo/code/installation-utilities/postgres-config.sh

Creating multiple instances in PostgreSQL12

Please replace [/local2]. This is your postgres data directory.

Please replace [star]. This is the instance start number Ex: 1

Please replace [end]. This is the instance end number Ex: 5

It will create instances from 1 to 5

$ sh  /nfs/home/btingle/work/tin_install_new/create-psql-instances.sh [/local2] [start] [end]