DB Configuration

In order to manage the appliance Postgres DBs, a “pgadmin” interface is available on https://<appliance IP>/pgadmin4/

It is also possible to log in to the machine itself using the “dbadmin@localhost.com” user.

You may need to change PostgreSQL sever to your time zone.

To get supported timezones you need to run below query (using pgadmin for example)

SELECT * FROM pg_timezone_names;

Then you can change your timezone on a DB using 

ALTER DATABASE "ProactivePack_TEST_SMP" SET timezone TO 'Europe/Paris';