Deploy
Learn how to deploy pgflow to production, monitor workflow execution, and maintain your system over time.
Supabase
Section titled “Supabase” Supabase.com Step-by-step guide to deploying pgflow workers to Supabase.com production
Node/Bun Process Workers Run workers as long-running processes on Railway, Fly, Docker, or VMs
Self-Hosted Supabase Deploy pgflow on self-hosted Supabase instances running on your own infrastructure
Configure
Section titled “Configure” Database connection Connection options and configuration for different environments
Database SSL Configure SSL certificates for secure database connections
Connection string encoding URL-encode special characters in database passwords
Observe
Section titled “Observe” Monitor flow execution Track workflow runs, step progress, and task status using SQL queries
Monitor workers health Check worker heartbeats and operational status
Troubleshoot
Section titled “Troubleshoot” Connection issues Diagnose and fix common database connection problems
Stalled tasks Diagnose and recover tasks stuck in 'started' status
Maintain
Section titled “Maintain” Update pgflow Safely upgrade pgflow to newer versions
Tune deployed flows Adjust retry behavior and timeouts for production flows
Prune records Clean up old workflow execution data to manage database size
