Promotic
WikipediaLinkedInYoutubeTwitterFacebook

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 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 PostgreSQL database
- by the PmaEventGroup object, if in this object the "Storage type" configurator is set to PostgreSQL database
- by the PmaAdo object
 
For next descriptions to the Postgres, see:

History:
Pm9.00.03: This data base is now supported in the PROMOTIC system. It can be used the same way as other supported databases in objects PmaAdo, PmaTrendGroup, PmaAlarmGroup and PmaEventGroup.
PROMOTIC 9.0.4 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice