Fly Managed Postgres - Creating subscription

Questions / Help
1

Hi there,

I am attempting to migrate our application from an unmanaged Fly Postgres cluster to a managed one with absolute minimal downtime.

I have changed the wal_level of the old cluster to logical and created a publication for all tables on the relevant database.

When I connect to the managed cluster, however, it seems I don’t have permission to subscribe:

dbname=> CREATE SUBSCRIPTION app_sub
  CONNECTION 'host=xxxxxxxx.flycast port=5432 dbname=dbname user=postgres password=xxxxxxxxxxx application_name=app_sub'
  PUBLICATION app_pub
  WITH (create_slot = true, copy_data = true, streaming = on, binary = on);
ERROR:  permission denied to create subscription
DETAIL:  Only roles with privileges of the "pg_create_subscription" role may create subscriptions.

I only have and am connected as the default fly-user created with the cluster, which as I understand it has the highest available permissions by default.

Is there any path available to get this working? If not, is there another way I can do this migration with near-zero downtime? I recognize that proper migration tools are still on the roadmap for Fly Managed Postgres but I figured that a manual solution would still be available.

2

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