Deploying the Database

The Broker requires a PostgreSQL database. The schema is automatically created when the Broker application starts up.

PostgreSQL Installation

1. Download the latest version of PostgreSQL.
2. Install with chosen values:
   • Port: your-database-port
   • Database: your-master-database-name
   • User: your-master-database-user
   • Password: your-master-database-password
3. No need to launch StackBuilder.

Create Database and User

With psql or a database management tool

-- Create a dedicated user (use a strong password)
CREATE USER your_database_user WITH ENCRYPTED PASSWORD 'your_secure_password';

-- Create the database
CREATE DATABASE broker OWNER your_database_user;

-- Grant privileges
GRANT ALL PRIVILEGES ON DATABASE broker TO your_database_user;