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 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 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: Created
PROMOTIC 9.0.12 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