# PostgreSQL Setup for AegisLM

## 🐳 Option 1: Docker (Easiest)

### Step 1: Install Docker Desktop
1. Download Docker Desktop from https://www.docker.com/products/docker-desktop/
2. Install and start Docker Desktop
3. Make sure Docker is running (check system tray)

### Step 2: Start PostgreSQL
```bash
cd d:\Projects\ALM\backend
docker-compose up -d postgres
```

### Step 3: Verify Connection
```bash
docker-compose logs postgres
```

### Step 4: Run Setup Script
```bash
python setup_postgresql.py
```

## 🪟 Option 2: Windows Native Installation

### Step 1: Download PostgreSQL
1. Go to https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
2. Download PostgreSQL for Windows (version 15 or later)
3. Run the installer

### Step 2: Installation Settings
- Password: `password` (match .env file)
- Port: `5432`
- Username: `postgres`
- Database: `aegislm` (create after installation)

### Step 3: Start PostgreSQL Service
1. Open Windows Services
2. Find "postgresql-x64-15" (or similar version)
3. Right-click → Start

### Step 4: Create Database
Open Command Prompt and run:
```bash
psql -U postgres -c "CREATE DATABASE aegislm;"
```

### Step 5: Test Connection
```bash
psql -U postgres -d aegislm
```

## 🌐 Option 3: Cloud PostgreSQL (Production Ready)

### Neon (Recommended for Production)
1. Sign up at https://neon.tech/
2. Create new project
3. Get connection string
4. Update .env file:
```
DATABASE_URL="postgresql+asyncpg://user:password@ep-xxx.us-east-2.aws.neon.tech/aegislm?sslmode=require"
```

### AWS RDS
1. Go to AWS Console → RDS
2. Create PostgreSQL instance
3. Configure security group to allow your IP
4. Update connection string

### Railway
1. Sign up at https://railway.app/
2. Add PostgreSQL service
3. Get connection string
4. Update .env file

## 🔧 Configuration

### Update .env file
```env
# Database - PostgreSQL Production
DATABASE_URL="postgresql+asyncpg://postgres:password@localhost:5432/aegislm"
DATABASE_POOL_SIZE=10
DATABASE_MAX_OVERFLOW=20
```

### Test Connection
```bash
python setup_postgresql.py
```

## 🚨 Troubleshooting

### Connection Refused Error
1. Check if PostgreSQL is running
2. Verify port 5432 is available
3. Check firewall settings
4. Verify credentials in .env

### Docker Issues
1. Make sure Docker Desktop is running
2. Check if port 5432 is already in use
3. Try `docker system prune` to clean up

### Permission Issues
1. Run Command Prompt as Administrator
2. Check PostgreSQL service status
3. Verify user permissions

## ✅ Verification

After setup, run:
```bash
python setup_postgresql.py
```

You should see:
```
🎉 POSTGRESQL SETUP COMPLETE!
✅ PostgreSQL is ready for production!
✅ All database operations working!
✅ Health checks passing!
```

## 🔄 Migration from SQLite

If you have existing data in SQLite:
1. Export data from SQLite
2. Import to PostgreSQL
3. Update .env to use PostgreSQL
4. Run setup script

## 🚀 Production Deployment

For production:
1. Use cloud PostgreSQL (Neon/AWS/Railway)
2. Enable SSL
3. Use environment variables for credentials
4. Set up connection pooling
5. Configure backups