aboutsummaryrefslogtreecommitdiff
path: root/src/delay_collector/DB_SETUP.md
diff options
context:
space:
mode:
authorAriel Costas Guerrero <ariel@costas.dev>2026-03-13 14:22:48 +0100
committerAriel Costas Guerrero <ariel@costas.dev>2026-03-13 14:23:10 +0100
commit90ad5395f6310da86fee9a29503e58ea74f3078b (patch)
tree9f2ad3cf539eaf338ed2d9afbf9f1f4d41cd39a8 /src/delay_collector/DB_SETUP.md
parentc9e2341a5b1e8dc03ba6e43c4e61ed2e5f4038c9 (diff)
Remove legacy stuff [skip ci]
Diffstat (limited to 'src/delay_collector/DB_SETUP.md')
-rw-r--r--src/delay_collector/DB_SETUP.md71
1 files changed, 0 insertions, 71 deletions
diff --git a/src/delay_collector/DB_SETUP.md b/src/delay_collector/DB_SETUP.md
deleted file mode 100644
index fedfb93..0000000
--- a/src/delay_collector/DB_SETUP.md
+++ /dev/null
@@ -1,71 +0,0 @@
-# PostgreSQL Database Setup
-
-This document describes how to set up the PostgreSQL database for the delay collector.
-
-## Prerequisites
-
-- PostgreSQL 18
-- psql
-
-## Database Setup
-
-### 1. Create Database and User
-
-Connect to PostgreSQL as superuser:
-
-```bash
-sudo -u postgres psql
-```
-
-Create database and user:
-
-```sql
--- Create database
-CREATE DATABASE busurbano;
-
--- Create user
-CREATE USER busurbano_collector WITH PASSWORD 'your_secure_password';
-
--- Grant privileges
-GRANT CONNECT ON DATABASE busurbano TO busurbano_collector;
-\c busurbano
-GRANT USAGE ON SCHEMA public TO busurbano_collector;
-GRANT INSERT, SELECT ON ALL TABLES IN SCHEMA public TO busurbano_collector;
-GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO busurbano_collector;
-ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT INSERT, SELECT ON TABLES TO busurbano_collector;
-ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT USAGE, SELECT ON SEQUENCES TO busurbano_collector;
-```
-
-### 2. Create Schema
-
-Run the schema file:
-
-```bash
-psql -U postgres -d busurbano -f schema.sql
-```
-
-Or from within psql:
-
-```sql
-\c busurbano
-\i schema.sql
-```
-
-## Configuration
-
-Update your `.env` file:
-
-```bash
-cp .env.example .env
-nano .env
-```
-
-Set the following:
-
-```env
-DB_HOST=localhost
-DB_PORT=5432
-DB_NAME=busurbano
-DB_USER=busurbano_collector
-DB_PASSWORD=your_secure_password
-```