Creating a Postgres database

The Capsule8 Console requires a PostgreSQL server. Consult our system requirements for more details.

Connect to the PostgreSQL server

Use the PostgreSQL client to connect to a PostgreSQL server. For example:

psql -h localhost -U postgres -p 5432

If successful, you should see the PostgreSQL prompt:

postgres=#

Create a database for the Capsule8 Console

From the PostgreSQL prompt, create a database, username, and password, then grant all access to this new user. For example:

CREATE DATABASE console;
CREATE USER console WITH PASSWORD 'password';
GRANT ALL ON DATABASE console TO console;

If successful, you should see a confirmation that these were created:

CREATE DATABASE
CREATE ROLE
GRANT

Connect the Capsule8 Console to the PostgreSQL database

With the username, password, and database name from the previous step, follow instructions in our configuration guide to connect the Capsule8 Console to the database.