1. Install PostgreSQL

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

• on OS X, using Homebrew brew install postgresql

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 which can be used to ingest data into Druid from a PostgreSQL database.