Ghost 5.78+ PostgreSQL beta: migration lock behavior on managed instances
Context Ghost 5.78 introduced experimental PostgreSQL support as an alternative to the MySQL 8 requirement for production. The CLI does not yet scaffold Postgres configurations, and the Knex-based migration runner relies on advisory locks that exhibit unresolved issues on managed PostgreSQL services (AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL).