Connfit DB — Infra na VPS (Status 2026-04-28)

Stack rodando em 187.127.24.217

Container	Imagem	Porta	Status
connfit_postgres	postgres:17-alpine	127.0.0.1:5433	✅ healthy
connfit_pgbouncer	edoburu/pgbouncer:latest	0.0.0.0:6432	✅ up
connfit_adminer	adminer:latest	127.0.0.1:8181	✅ up

Arquivos na VPS

• /home/connfit-db/docker-compose.yml
• /home/connfit-db/.env (senha do banco)
• /home/connfit-db/scripts/backup.sh

Credenciais

• User: connfit_admin
• Database: connfit_marketing
• Senha: em /home/connfit-db/.env na VPS
• Backup: diário às 3h → /var/backups/connfit-db/

Connection String (Next.js / Drizzle)

DATABASE_URL=postgresql://connfit_admin:SENHA@187.127.24.217:6432/connfit_marketing

prepare: false obrigatório no postgres.js (PgBouncer transaction mode)

Adminer (interface web)

• URL: https://db.kodama.solutions ← pendente DNS
• Login: admin / Connfit@DB2026!
• ⚠️ DNS db.kodama.solutions → 187.127.24.217 precisa ser criado
• Após DNS: certbot --nginx -d db.kodama.solutions --non-interactive --agree-tos -m devops@kodama.solutions

Pendente para fechar KOD-438

• DNS: criar registro A db.kodama.solutions → 187.127.24.217
• Rodar certbot após DNS propagado
• Drizzle setup no repo connfit-marketing com DATABASE_URL
• Schema inicial (brand_identity + archetypes) + primeira migration
• Adicionar DATABASE_URL no Vercel (connfit-marketing)