MANUAL_MIGRATION_GUIDE.md

Manual A/B Testing Migration Guide

Since automatic migration failed due to PostgreSQL password issues, here's how to do it manually:

Step 1: Connect to PostgreSQL

# Try one of these:
psql -U postgres
# OR
sudo -u postgres psql
# OR
psql postgresql://postgres@localhost:5432/postgres

Step 2: Create Database (if needed)

CREATE DATABASE myapp;
\c myapp  -- Connect to database

Step 3: Run the SQL

Copy and paste the SQL from sql/create-ab-testing-tables.sql into psql.

Or run it from file:

# If connected as postgres user
psql -d myapp -f sql/create-ab-testing-tables.sql

# Or from within psql
\i sql/create-ab-testing-tables.sql

Step 4: Verify

-- Check tables were created
SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'public' 
AND table_name IN ('experiments', 'experiment_conversions', 'experiment_assignments', 'feature_flags');

-- Check feature flags
SELECT key, enabled, rollout_pct, target_cohort FROM feature_flags;

Alternative: Reset PostgreSQL Password

If you forgot the PostgreSQL password:

# Stop PostgreSQL
sudo systemctl stop postgresql

# Edit pg_hba.conf to allow trust authentication
sudo nano /etc/postgresql/*/main/pg_hba.conf
# Change "md5" to "trust" for local connections

# Restart PostgreSQL
sudo systemctl start postgresql

# Connect without password
psql -U postgres

# Reset password
ALTER USER postgres WITH PASSWORD 'newpassword';

# Restore pg_hba.conf and restart

Quick Test Without Database

If you just want to test the A/B testing logic without database:

1. Comment out TypeORM decorators in entities (temporarily)
2. Use mock repositories in tests
3. The service logic works even without database tables

The A/B Testing Service is READY

The implementation is complete. Once you get PostgreSQL working, run the migration and the service will be fully operational.