Managed Postgres - Moving regions

[Robert1]

Hi there! I want to change my postgres region but im wondering if the process has changed or if there is official documentation on this, thank you!

[shaun]

If you’re running PG on Machines you can find instructions here:

Fly Postgres

[Robert1]

would the managed postgres count as machines?

[shaun]

If you run fly apps list there’s a PLATFORM column that indicates whether your app is running on machines or nomad.

[Robert1]

my postgres db seems to be running on nomad, so will this tutorial apply to me?

[shaun]

Here are the steps for Nomad:

What is the correct process to change the postgres leader region?

Hey there, So it’s a bit of a process, but i’ll walk you through it. Step 1: Adjust your apps primary region. Pull down your fly.toml file if you haven’t already. fly config save --app <app-name> Modify the PRIMARY_REGION value inside of your fly.toml file [env] PRIMARY_REGION = "lax" Deploy your app. WARNING: Your app will not accept writes until your issue the failover in Step 2. The HAProxy routes connections to the primary and leverages the PRIMARY REGION env var. This also requir…

The steps are very similar, but the failover process is not as streamlined.