15 lines
477 B
SQL
15 lines
477 B
SQL
-- Create databases for Airbyte OSS
|
|
-- These databases will be used by the Airbyte deployment in 04-ingestion
|
|
|
|
-- Main Airbyte database
|
|
CREATE DATABASE airbyte;
|
|
|
|
-- Temporal workflow engine databases
|
|
CREATE DATABASE temporal;
|
|
CREATE DATABASE temporal_visibility;
|
|
|
|
-- Grant permissions to postgres user
|
|
GRANT ALL PRIVILEGES ON DATABASE airbyte TO postgres;
|
|
GRANT ALL PRIVILEGES ON DATABASE temporal TO postgres;
|
|
GRANT ALL PRIVILEGES ON DATABASE temporal_visibility TO postgres;
|