error when running with PostgreSQL

[Pixell-droid]

I'm getting a "relation does not exist" error when running with PostgreSQL. How do I set up the database schema?

[flow-pie]

This means the database tables haven't been created yet. Chamaa.API uses Flyway for database migrations in production. Here's how to fix it:

Option 1: Let Flyway Handle It (Recommended)

Make sure your application-prod.properties or environment variables are set:

spring.flyway.enabled=true
spring.jpa.hibernate.ddl-auto=validate

Flyway will automatically run migration scripts from src/main/resources/db/migration/ on startup.

Option 2: Manual Setup

If you're setting up PostgreSQL manually:

# Create the database
psql -U postgres -c "CREATE DATABASE chamaa_db;"
# Run migrations manually
cd apps/backend
./mvnw flyway:migrate -Dflyway.url=jdbc:postgresql://localhost:5432/chamaa_db

Option 3: Quick Dev Setup with H2

For local development, skip PostgreSQL entirely and use H2:

./mvnw spring-boot:run -Dspring-boot.run.profiles=dev

The dev profile uses an in-memory H2 database with PostgreSQL compatibility mode. Schema is created automatically on startup.

Common Pitfalls

1. Wrong profile active - Check that SPRING_PROFILES_ACTIVE=prod is set if using PostgreSQL
2. Database doesn't exist - Flyway can't create the database, only the tables. Create chamaa_db first
3. Permission issues - Ensure your DB user has CREATE TABLE privileges
   See docs/DATABASE_SETUP.md for the full configuration reference.