Setup PostgreSQL for IM&P

docker pull bitnami/postgresql:latest

docker run --name postgresql -d  --restart=always -p 5432:5432 -e POSTGRESQL_PASSWORD=password123 bitnami/postgresql:latest

install psql and connect

psql -h 127.0.0.1 -p 5432 -d template1 -U postgres

CREATE ROLE tcuser LOGIN CREATEDB;
ALTER ROLE tcuser WITH SUPERUSER;
CREATE DATABASE tcmadb WITH OWNER tcuser ENCODING 'SQL_ASCII' TEMPLATE template0;
ALTER ROLE tcuser WITH PASSWORD 'password123';

connect to tcamdb via psql

psql -h 127.0.0.1 -p 5432 -d tcmadb -U tcuser

CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS '$libdir/plpgsql' LANGUAGE C;