PostgreSQL Metadata Store

    1. Install PostgreSQL

    Use your favorite package manager to install PostgreSQL, e.g.:

    • on Ubuntu/Debian using apt apt-get install postgresql
    1. Create a druid database and user

    On the machine where PostgreSQL is installed, using an account with proper postgresql permissions:

    Create a druid database owned by the user we just created

    Note: On Ubuntu / Debian you may have to prefix the createuser and createdb commands with sudo -u postgres in order to gain proper permissions.

    1. Configure your Druid metadata storage extension:

    Configuration

    In most cases, the configuration options map directly to the .

    The PostgreSQL extension provides an implementation of an SqlFirehose which can be used to ingest data into Druid from a PostgreSQL database.