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 postgres JDBC connection options.

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