Skip to content

Commit 803731b

Browse files
committed
Cutover details
1 parent 25144fa commit 803731b

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

pgml-cms/blog/how-we-migrated-from-aws-to-gcp-with-minimal-downtime.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -117,9 +117,9 @@ The database files were the same on GCP and AWS, if one checked them for their "
117117

118118
### The cutover
119119

120-
The final step was to move our customers' traffic from AWS to GCP, and do so without losing a byte of data. We picked the lowest traffic period, midnight Pacific time, and shut down our AWS primary.
120+
The final step was to move our customers' traffic from AWS to GCP, and do so without losing a byte of data. We picked the lowest traffic period, midnight Pacific time, paused our [PgCat](/docs/product/pgcat/) pooler, waited for all remaining transactions to replicate, and shut down our AWS primary.
121121

122-
As soon as the Systemd service stopped, we changed the DNS record to point to our GCP standby and ran `SELECT pg_promote()`. Traffic moved over almost immediately, thanks to our low DNS TTL and we were back in business.
122+
As soon as the Systemd service stopped, we changed the DNS record to point to our GCP standby and ran `SELECT pg_promote()`. Traffic moved over almost immediately, thanks to our low DNS TTL, and we were back in business.
123123

124124
## Lessons learned
125125

0 commit comments

Comments
 (0)