Monokot Server 1.x
  • What is Monokot Server?
  • Quickstart
  • 🐸Basics
    • Supported OS and Hardware
    • Installation
    • Licensing
    • OPC UA
      • UA TCP Endpoint
      • UA Settings
      • Client Certificates
      • Aliases
      • Access to Object Settings
      • Troubleshooting
    • Security Certififcate
    • Users & Roles
    • Administrator GUI
      • Event Log
      • Users in Monokot Server Administrator
      • Roles in Monokot Server Administrator
    • Startup Parameters
  • 🦊Tags & Devices
    • Devices
      • Diagnostics
      • Devices in the Monokot Server Administrator
    • Tags
      • Parameters
      • Change Trigger
      • Tags in Monokot Server Administrator
        • Go Online
        • Group Action
        • Import & Export
    • Modbus Connectivity
      • Parameters
      • Addressing
      • Diagnostics
    • Siemens Connectivity
      • Parameters
      • Addressing
      • Access to DBs area in S7-1200/S7-1500
    • IEC 60870-5-104 Connectivity
      • Parameters
      • Addressing
      • Time Conversion
      • Diagnostics and Commands
    • OPC UA Connectivity
      • Parameters
      • Addressing
      • Diagnostics
      • How to: Importing OPC UA items
      • How to: Pulling Security Certificate
    • InfluxDB Connectivity (Connector)
      • Parameters
      • Addressing
      • Query Result and Data Mapping
      • Diagnostics
      • How to: Configure for InfluxDB 2.x
    • SNMP Connectivity
      • Parameters
      • Addressing
      • UDP Considerations
  • 🐺Time Series & Stores
    • Stores
      • Backlog
      • Diagnostics
      • Stores in Monokot Server Administrator
    • Time Series
      • Parameters
      • Deadband
      • Sampling
      • Last Sample Repeat
      • Time Series in Monokot Server Administrator
        • Group Action
        • Import & Export
    • InfluxDB Connectivity (Store)
      • Parameters
      • Addressing
      • Data Structure
      • About Metadata
      • Diagnostics
      • How to: Configure for InfluxDB 2.x
    • PostgreSQL Connectivity
      • Parameters
      • Addressing
      • Database Design
      • Data Compression
    • REST Connectivity
      • Parameters
      • Addressing
      • Message Script
      • RestRequestMessage
      • DataContext
      • TimeSeries
  • 🐻Scripts
    • Overview
    • Expression
      • Parameters
      • Import & Export
      • Go Online
    • Programming Examples
      • How to: Calculate Arithmetic Mean
      • How to: DoNothing
      • How to: Writing to Tag
      • How to: Inverting Bits
      • How to: Execute SQL
      • How to: Run Ping
      • How to: Do Simulation
      • How to: String Formatting
      • How to: OPC UA Method
      • How to: Initialize Device Settings from File
    • API
      • Bundle
      • BundlePair
      • Context
      • DataMap
      • DataMapPair
      • DataTriggerInfo
      • Expression
      • MosCrypto
      • MosDirectories
      • MosFiles
      • MosOdbc
      • MosOdbcReader
      • MosProcess
      • MosProcessExecuteResult
      • MosText
      • MosUtils
      • ValueState
Powered by GitBook
On this page
  • General
  • Security
  • Performance
  • Advanced
  1. Time Series & Stores
  2. PostgreSQL Connectivity

Parameters

General

  • Host: contains target IP address or database server hostname.

  • Port: contains database server port (5432 by default).

  • Database: contains name of the database.

  • Schema: contains name of the schema.

  • Table Prefix: contains prefix of the tables.

  • Connection Timeout: contains the time interval (in milliseconds) within which the connection to the database should be established. If the connection is not established within the specified time, an error occurs.

  • Request Timeout: contains time interval (in milliseconds) within which the response from the database server must be received. If the response is not received during the specified interval, an error occurs.

  • Max. Buffer Size: contains maximum size of sample buffer for each time series that is accumulated in the server memory.

  • Wait after Write: contains timeout interval (in milliseconds) before the start of next data writing to the store.

  • Wait after Error: contains timeout interval (in milliseconds) in case an error occurs during data writing or store preparation.

  • Inter-request Interval: contains timeout interval (in milliseconds) before sending the next request. It is used if data doesn’t fit in one request.

Security

  • Username: contains username.

  • Password: contains password.

  • Use SSL: specifies that it is necessary to verify database server SSL certificate.

  • SSL Verification: contains verification mode of database server SSL certificate:

    • Accept any.

    • Verify chain of trust by using a store of certificates of the operating system.

    • Verify chain of trust by using custom certificate of certification authority.

  • Custom CA File: contains custom certificate of certification authority.

Performance

  • Series per Request: contains maximum number of time series that can be written per one request.

  • Samples per Request: contains maximum number of samples for each time series that can be written per one request.

  • Max. Buffer Size: contains maximum size of sample buffer for each time series that is accumulated in the server memory.

  • Wait after Write: contains timeout interval (in milliseconds) before the start of next data writing to the store.

  • Wait after Error: contains timeout interval (in milliseconds) in case an error occurs during data writing or store preparation.

  • Inter-request Interval: contains timeout interval (in milliseconds) before sending the next request. It is used if data doesn’t fit in one request.

Advanced

  • Add Server UID to Tag: specifies that for all store associated time series server UID will be added as su tag value (record metadata).

  • Add Store UID to Tag: specifies that for all store associated time series store UID will be added as stu tag value (record metadata).

  • Add Time Series UID to Tag: specifies that for all store associated time series time series UID will be added as tsu tag value (record metadata).

  • Add Time Series Path to Tag: specifies that for all store associated time series string path to time series will be added as tsp tag value (record metadata).

  • Add Time Series Comment to Tag: specifies that for all store associated time series comment to time series will be added as tsc tag value (record metadata).

  • Use Server UID in ‘Hash’ Addresses: specifies that unique server identifier should be used to generate Hash addresses.

  • Database Auto-creation: if the parameter is set, database will be created automatically.

  • Schema Auto-creation: if the parameter is set, schema will be created automatically.

  • Table Auto-creation: if the parameter is set, data and metadata tables will be created automatically.

  • Index Auto-creation: if the parameter is set, indexes for tables will be created automatically.

PreviousPostgreSQL ConnectivityNextAddressing

Last updated 2 years ago

🐺