Skip to content

Variable schema for postgressql output plugin #16747

Open
@chris9734

Description

@chris9734

Use Case

I have a PostgresSQL DB with several schemas. schemaA, schemaB, etc., in which I feed data from sensors through the mqtt_consumer plugin.

After a bit of processing, the measurement names look like
"correspondingSchema_sensorName"

Expected behavior

I would like to be able to set the schema-name from a tag, which I would drop afterwards.

Actual behavior

Right now I have to define several outputs, one for each schema:

[[outputs.postgresql]]
namepass = ["schemaA_*"]
schema = "schemaA"

[[outputs.postgresql]]
namepass = ["schemaB_*"]
schema = "schemaB"

Additional info

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    feature requestRequests for new plugin and for new features to existing pluginshelp wantedRequest for community participation, code, contributionsize/s1 day effort, great beginniner issue

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions