I'm on a pro plan.
I want to create a postgres db in europe. By default it was created in US and when I tried to migrate it to EU it said it failed to migrate. Now it says that the DB is in EU and the attached disk volume is in US and this is what my logs says:
Can I recover from this on my own?
Error: Database is uninitialized and superuser password is not specified.
You must specify POSTGRES_PASSWORD to a non-empty value for the
superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".
You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
connections without a password. This is *not* recommended.
See PostgreSQL documentation about "trust":
https://www.postgresql.org/docs/current/auth-trust.html
This(the image) is what it says when I enter the disk volume. It's readonly so I can't select another region.