blob: fedfb93499864c07af170c90cf95e5be4a8ad115 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
# 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
```
|
