PostgreSQL

PostgreSQL (Postgres) is a database product of the client/server type (the last known version as for 6/2019 is version Postgres 11). Postgres is available for free download at https://www.postgresql.org

Work with Postgres database

- The ODBC driver provided together with the database psqlODBC allows time storage with the precision up to miliseconds TIMESTAMP(3).

- PostgreSQL is provided only in 64-bit version, however the mentioned ODBC driver allows access to both 32 and 64-bit versions of the PROMOTIC system simultaneously.

The database can be filled:

- by the PmaTrendGroup object, if in this object the "Storage type" configurator is set to Database PostgreSQL cyclic

- by the PmaAlarmGroup object, if in this object the "Storage type" configurator is set to Database PostgreSQL cyclic

- by the PmaEventGroup object, if in this object the "Storage type" configurator is set to Database PostgreSQL cyclic

- by the PmaAdo object

For next descriptions to the Postgres, see:

- Examples of Postgres database usage.

- Data types in Postgres.