Creating PostgreSQL database for SSB
You need to create the PostgreSQL database that will be used for the Streaming SQL Console and the Materialized View Engine.
- Connect to PostgreSQL:
sudo -u postgres psql
- Create databases for the Streaming SQL
Console:
CREATE ROLE ssb_admin LOGIN PASSWORD '<password>'; CREATE DATABASE ssb_admin OWNER ssb_admin ENCODING 'UTF8';
- Create databases for the Materialized View
Engine:
CREATE ROLE ssb_mve LOGIN PASSWORD '<password>'; CREATE DATABASE ssb_mve OWNER ssb_mve ENCODING 'UTF8';
- Confirm that you have created the Streaming SQL Console and Materialized
View Engine database using the
\l
command.