TIBCO BPM Enterprise (BPME) 5.x developer server installation builds a Postgres database container.  This database can be accessed using the below methods - 

1. Using docker command line 
2. Using a database client like pgAdmin or DBeaver

Below are the instructions to connect to the Postgres database of BPME 5.x developer server - 

1. Using docker command line - 

i. Access the postgres container using the below command -
docker exec -it bpm-postgres bash

ii. Connect to the database using the bpmuser  - 
psql postgres bpmuser

iii. Execute the SQL queries from the Postgres shell
For example, the below query lists all the tables from the bpm schema. 

SELECT * FROM pg_catalog.pg_tables WHERE schemaname='bpm';

2. Using a database client like pgAdmin or DBeaver:

Enter the connection details as below - 

i. Hostname: Use either the IP address of the Postgres docker container or the hostname of the docker host

To obtain the IP address of the Postgres docker container.

docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' bpm-postgres

ii. Port: 5432
iii. Username: bpmuser
iv. Password: bpmuser