Postgres proxy

    Attention

    The filter is experimental and is currently under active development. Capabilities will be expanded over time and the configuration structures are likely to change.

    Warning

    The postgreql_proxy filter was tested only with Postgres frontend/backend protocol version 3.0, which was introduced in Postgres 7.4. Earlier versions are thus not supported. Testing is limited anyway to not EOL-ed versions.

    The Postgres proxy filter should be chained with the TCP proxy as shown in the configuration example below:

    Every configured Postgres proxy filter has statistics rooted at postgres.<stat_prefix> with the following statistics:

    The Postgres filter emits Dynamic Metadata based on SQL statements carried in and Parse messages. statistics Counter tracks how many times SQL statement was parsed successfully and metadata was created. The metadata is emitted in the following format:

    Name

    Type

    Description

    <table.db>

    string

    The resource name in table.db format.

    []

    list

    A list of strings representing the operations executed on the resource. Operations can be one of insert/update/select/drop/delete/create/alter/show.

    Attention

    Parsing SQL statements and emitting Dynamic Metadata can be disabled by setting to false.