Describe the pull request

Adds embedded PostgreSQL support for simplified deployment and testing. Enables running pgrokd without external database dependencies.

Link to the issue: n/a

Changes

Configuration (internal/conf/conf.go, pgrokd.example.yml):

• Added enable_embedded bool to Database struct

Database initialization (internal/database/db.go):

• Extended DB struct with embeddedServerHandle and embeddedWorkspace lifecycle fields
• Added bootEmbeddedServer() - creates temp workspace, configures and starts embedded Postgres
• Added resolveHostAndPort() - forces localhost when embedded mode enabled
• Modified New() - conditionally starts embedded instance before gorm connection
• Added Terminate() - stops embedded instance and cleans workspace

Lifecycle management (pgrokd/cli/main.go):

• Added SIGINT/SIGTERM handling to call db.Terminate() for cleanup

Tests (internal/database/db_test.go):

• Coverage for host resolution logic and config assembly

Consent

• I agree to follow the Code of Conduct by submitting this pull request.
• I have read and acknowledged the Contributing guide.
• I have added test cases to cover the new code or have provided the test plan.

Test plan

Create pgrokd.yml with:

database:
  port: 5555
  user: "test"
  password: "test"
  database: "pgrokd"
  enable_embedded: true

Run pgrokd -config pgrokd.yml. Verify:

• Postgres starts on specified port
• Tables auto-migrate successfully
• Servers start (SSH, web, proxy)
• Clean shutdown with Ctrl+C removes temp directories

💬 We'd love your input! Share your thoughts on Copilot coding agent in our 2 minute survey.