MPG administration options

Questions / Help
,
1

I’m hosting an application on Fly, and I’m trying to migrate the current unmanaged Postgres to a Managed Postgres. For testing new features, I’ve some automations in place to create databases and users on demand, which is done by leveraging flyctl ssh and running commands in the unmanaged Postgres.

            flyctl ssh console -a fake-db -C "su postgres -c 'psql -p 5433 -c \"CREATE DATABASE \\\"${DATABASE_NAME}\\\" OWNER postgres;\"'" || echo "Database may already exist"
            flyctl ssh console -a fake-db -C "su postgres -c 'psql -p 5433 -c \"CREATE USER \\\"${DATABASE_USER}\\\" WITH ENCRYPTED PASSWORD '\''${DATABASE_PASSWORD}'\'';\"'" || echo "User may already exist"

The problem that I’m having is that, as far as I can tell, we can’t create users or databases without using the dashboard while using Managed Postgres. Are there any plans to support this use case?

2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.