postgres

Postgres reader

Postgres reader provides message repository implementation for Postgres.

Readers - DB Schema

CREATE TABLE json (
    created   BIGINT,
    subtopic  VARCHAR(254),
    publisher VARCHAR(254),
    protocol  TEXT,
    payload   JSONB
);

CREATE TABLE messages (
    subtopic     VARCHAR(254) NOT NULL,
    publisher    UUID NOT NULL,
    protocol     TEXT,
    name         TEXT NOT NULL,
    unit         TEXT,
    value        DOUBLE PRECISION,
    string_value TEXT,
    bool_value   BOOLEAN,
    data_value   TEXT,
    sum          DOUBLE PRECISION,
    time         DOUBLE PRECISION NOT NULL,
    update_time  DOUBLE PRECISION
);

Configuration

The service is configured using the environment variables presented in the following table. Note that any unset variables will be replaced with their default values.

Deployment

The service itself is distributed as Docker container. Check the postgres-reader service section in docker-compose to see how service is deployed.

To start the service, execute the following shell script:

# download the latest version of the service
git clone https://github.com/MainfluxLabs/mainflux

cd mainflux

# compile the postgres writer
make postgres-writer

# copy binary to bin
make install

# Set the environment variables and run the service
MF_POSTGRES_READER_LOG_LEVEL=[Service log level] \
MF_POSTGRES_READER_PORT=[Service HTTP port] \
MF_POSTGRES_READER_CLIENT_TLS =[TLS mode flag] \
MF_POSTGRES_READER_CA_CERTS=[Path to trusted CAs in PEM format] \
MF_POSTGRES_READER_DB_HOST=[Postgres host] \
MF_POSTGRES_READER_DB_PORT=[Postgres port] \
MF_POSTGRES_READER_DB_USER=[Postgres user] \
MF_POSTGRES_READER_DB_PASS=[Postgres password] \
MF_POSTGRES_READER_DB=[Postgres database name] \
MF_POSTGRES_READER_DB_SSL_MODE=[Postgres SSL mode] \
MF_POSTGRES_READER_DB_SSL_CERT=[Postgres SSL cert] \
MF_POSTGRES_READER_DB_SSL_KEY=[Postgres SSL key] \
MF_POSTGRES_READER_DB_SSL_ROOT_CERT=[Postgres SSL Root cert] \
MF_JAEGER_URL=[Jaeger server URL] \
MF_THINGS_AUTH_GRPC_URL=[Things service Auth GRPC URL] \
MF_THINGS_AUTH_GRPC_TIMEOUT=[Things service Auth gRPC request timeout in seconds] \
$GOBIN/mainfluxlabs-postgres-reader

Usage

Starting service will start consuming normalized messages in SenML format.