/trex.db.setup

Set Up Database

Start a fresh PostgreSQL container and run all migrations. If a database already exists, this will tear it down first.

Instructions

1. Check if a PostgreSQL container is already running:

   docker ps -a --filter name=ambient-api-server-postgres --format "{{.Names}} {{.Status}}"

2. If a container exists, tear it down first:

   make db/teardown

3. Start a fresh PostgreSQL container:

   make db/setup

4. Wait for PostgreSQL to be ready:

   sleep 2

5. Build the binary if not already built:

   make binary

6. Run migrations:

   ./ambient-api-server migrate

When to Use This

• First-time database setup
• After generating a new Kind (new migration added)
• After pulling changes that include new migrations
• When integration tests fail with "relation does not exist" or column errors
• When the database schema is corrupted or out of sync

Database Connection Details

Connection details are stored in the `secrets/` directory files (`db.host`, `db.port`, `db.name`, `db.user`, `db.password`).