# postgresql.conf
wal_level = logical
max_replication_slots = 10

name: 'electric-backend'
services:
  postgres:
    image: postgres:16-alpine
    environment:
      POSTGRES_DB: electric
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: password
    ports: ['54321:5432']
    volumes: ['./postgres.conf:/etc/postgresql/postgresql.conf:ro']
    tmpfs: ['/var/lib/postgresql/data', '/tmp']
    command: ['postgres', '-c', 'config_file=/etc/postgresql/postgresql.conf']

  electric:
    image: electricsql/electric:latest
    environment:
      DATABASE_URL: postgresql://postgres:password@postgres:5432/electric?sslmode=disable
      ELECTRIC_SECRET: ${ELECTRIC_SECRET}
    ports: ['3000:3000']
    volumes: ['electric_data:/var/lib/electric']
    depends_on: ['postgres']

volumes:
  electric_data:

npx @electric-sql/start my-app
pnpm claim && pnpm deploy

livenessProbe:
  httpGet:
    path: /v1/health
    port: 3000
readinessProbe:
  exec:
    command: ['curl', '-sf', 'http://localhost:3000/v1/health']
  # Use exec, not httpGet — 202 means "alive but not ready"
  # Only 200 means fully ready for traffic

-- When stopping Electric for extended periods:
SELECT pg_drop_replication_slot('electric_slot_default');

-- Prevent unbounded WAL growth:
ALTER SYSTEM SET max_slot_wal_keep_size = '10GB';
SELECT pg_reload_conf();

# postgresql.conf (default)
wal_level = replica

wal_level = logical
max_replication_slots = 10

docker run electricsql/electric \
  -e DATABASE_URL=postgres://user:pass@host/db

docker run electricsql/electric \
  -e DATABASE_URL=postgres://user:pass@host/db \
  -e ELECTRIC_SECRET=my-secret-key

electric:
  image: electricsql/electric:latest
  # No volume — shape cache lost on restart

electric:
  image: electricsql/electric:latest
  volumes: ['electric_data:/var/lib/electric']

ELECTRIC_QUERY_DATABASE_URL=postgres://user:pass@pooler:6432/db

ELECTRIC_POOLED_DATABASE_URL=postgres://user:pass@pooler:6432/db