Replicate to another Supabase Instance
Hi.
I tried to follow along this guide:
https://supabase.com/docs/guides/database/postgres/setup-replication-external
i have some tables i want to replicate from one supabase project to secound one. on the source i executed:
on the second instance i tried to create subscription:
But when i run the command i get this error:
ERROR: 42501: must be superuser to create subscriptions
How can i add a subscription in supabase?
I tried to follow along this guide:
https://supabase.com/docs/guides/database/postgres/setup-replication-external
i have some tables i want to replicate from one supabase project to secound one. on the source i executed:
CREATE PUBLICATION video_publication FOR TABLE videos, speaker, videos_speaker;
select pg_create_logical_replication_slot('video_slot', 'pgoutput');on the second instance i tried to create subscription:
CREATE SUBSCRIPTION subscribe_video_db
CONNECTION 'host=db.project.supabase.co port=5432 dbname=postgres user=postgres password=password'
PUBLICATION video_publication;But when i run the command i get this error:
ERROR: 42501: must be superuser to create subscriptions
How can i add a subscription in supabase?
Example to setup logical replication using publish-subscribe to a Postgres database outside of Supabase
