How to access Postgresql on docker container openremote?

[Delfin24]

hello everyone, how to access postgresql in openremote? I have set the port and IP on docker-compose.yml but it is not accessible.

[martin.peeters]

A PostgreSQL database doesn’t come with a Web UI out of the box.

You can use third party software like pgAdmin for this,
or manually use the psql CLI within the docker container as mentioned here on the wiki.
They should both give full access to query all data from the OpenRemote database.

[Delfin24]

How do I see the value of assets on openremote in pgAdmin?

[martin.peeters]

Hey!

This should be no different than gathering data from any other SQL database.
Either look them up in pgAdmin, or manually execute the SQL query.
There are lots of tutorials on the internet on how to do this.

You can use the asset table to query get values of attributes.

Hope this helps!