How to install PostgreSQL database for OMOPv6.0 using Docker

1. Goto Athena.ohdsi.org to download Vocabularies. ./cpt.sh <your_account>
2. Get DDLs from https://github.com/OHDSI/CommonDataModel
3. Get docker image of PostgreSQL: docker pull postgres
4. Run

docker run --name omopv60 -d -p 5432:5432 -e POSTGRES_PASSWORD=<password> --restart unless-stopped postgres:latest

4. Create database and schema create database with owner postgres;

5. Run DDL from ODHSI. DDLs are in CommonDataModel folder. Goto postgresql folder.

psql -h localhost -p <port> -U postgres -W -d <database> -f CommonDataModel/OMOP\ CDM\ postgresql\ ddl.txt
5.1 You may want to run the follow if you want to index them.
  psql -h localhost -p <port> -U postgres -W -d <database> -f CommonDataModel/PostgreSQL/OMOP\ CDM\ indexes\ required\ -\ PostgreSQL.sql

6. Run DDLs for f_observation_view, f_immunizqtion_view, and f_person omoponfhir_f_person_ddl.txt omoponfhir_v6.0_f_observation_view_ddl.txt omoponfhir_v6.0_f_immunization_view_ddl.txt
7. Load vocabularies downloaded from Athena. change the ddl in VocaImport/ to point to the vocabulary files. And change COPY to \copy
8. Use fhir_names ETL to load f_person if your database already has data in it. Read the instruction in fhir_names/ folder.
9. Indexing all IDs in OMOP tables