Data Nova Infrastructure

Infrastructure setup for Data Nova using Docker Compose. This repository provisions a robust local development environment with:

• TimescaleDB (PostgreSQL 16 with pgvector & pgai pre-installed)
• pgAdmin (Database management UI)

Services Overview

1. TimescaleDB (PostgreSQL)

• Service Name: db
• Image: ghcr.io/timescale/pgai:latest-pg16
• Purpose: Core Relational DB + Vector Store + AI Agent.
• Extensions: pgvector, pgai (enabled manually post-launch).
• Port: 5432
• Persistence: pg_data volume.

2. pgAdmin

• Service Name: pgadmin
• Image: dpage/pgadmin4
• Purpose: Web UI for Database Management.
• Port: 5050 (Host) -> 80 (Container).

Quick Start

1. Clone the Repository

git clone https://github.com/Data-Nova-Project/datanova-infra.git
cd datanova-infra

2. Start the Stack

Start all services in the background.

docker-compose up -d

Wait ~30 seconds for the database to fully initialize.

3. Initialize AI Extensions (One-Time Setup)

Since we are using a persistent volume, you only need to run this command once to enable the AI capabilities.

docker exec -it reportiq-db psql -U admin -d reportiq_db -c "CREATE EXTENSION IF NOT EXISTS vector; CREATE EXTENSION IF NOT EXISTS ai CASCADE;"

4. Access the Services

• TimescaleDB: localhost:5432 (User: admin, Pass: adminpassword)
• pgAdmin: http://localhost:5050 (User: admin@example.com, Pass: admin123)
  • Note: When adding the server in pgAdmin, use Host name: db

Resetting the Environment (Wipe Data)

To delete all data (Database & Files) and start fresh:

docker-compose down -v

Volumes

Persistent data is stored in Docker Named Volumes:

• pg_data: PostgreSQL tables and vectors.

License

MIT