NeonN
Neon2y ago
1 reply
recent-teal

Staging and Production (Blue/Green) Deployments on Neon?

Hi, we have a live web application that uses a Postgres database on the neon
main
branch. A data pipeline that loads this database with fresh data takes a while to run (20-30 minutes), and the updates involve refreshing data, which essentially causes application downtime.

Is there a way to have a staging branch to update the database, and to propagate the changes to
main
, which the application sees after the update has completed, so that the database that the app utilizes is never down or refreshed through the pipeline directly, and instead copies over changes from staging?

Cheers.
Was this page helpful?