Store telemetry data in PostgreSQL, a powerful open-source relational database. Outbound targets write to the ProxusDeviceData table.
open_in_new
Official Documentation
postgresql.org
Configuration Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Server | Yes | string | PostgreSQL server hostname or IP. |
| User | Yes | string | Database username. |
| Password | Yes | string | Database password. |
| Database | Yes | string | Database name. |
| Port | No | int | PostgreSQL port (default 5432). |
Example Configuration
Server=192.168.1.100
Port=5432
Database=proxus
User=proxus_writer
Password=*****Data Schema
Proxus automatically creates tables with the following schema:
CREATE TABLE ProxusDeviceData (
Oid SERIAL PRIMARY KEY,
DeviceId INT NOT NULL,
DeviceName VARCHAR(255),
"Key" VARCHAR(255) NOT NULL,
"Value" TEXT NOT NULL,
DataType VARCHAR(64) NOT NULL,
"Time" TIMESTAMPTZ NOT NULL
);Performance Tips
- Use appropriate indexes for query patterns (e.g.,
DeviceId,Time). - Enable connection pooling in the connection string
- Consider partitioning tables by time for large datasets