diff options
| author | Ariel Costas Guerrero <ariel@costas.dev> | 2026-03-13 14:22:48 +0100 |
|---|---|---|
| committer | Ariel Costas Guerrero <ariel@costas.dev> | 2026-03-13 14:23:10 +0100 |
| commit | 90ad5395f6310da86fee9a29503e58ea74f3078b (patch) | |
| tree | 9f2ad3cf539eaf338ed2d9afbf9f1f4d41cd39a8 /src/delay_collector/DB_SETUP.md | |
| parent | c9e2341a5b1e8dc03ba6e43c4e61ed2e5f4038c9 (diff) | |
Remove legacy stuff [skip ci]
Diffstat (limited to 'src/delay_collector/DB_SETUP.md')
| -rw-r--r-- | src/delay_collector/DB_SETUP.md | 71 |
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 -``` |
