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:

CREATE PUBLICATION video_publication FOR TABLE videos, speaker, videos_speaker;

select pg_create_logical_replication_slot('video_slot', 'pgoutput');

CREATE PUBLICATION video_publication FOR TABLE videos, speaker, videos_speaker;

select pg_create_logical_replication_slot('video_slot', 'pgoutput');

CREATE PUBLICATION video_publication FOR TABLE videos, speaker, videos_speaker;

select pg_create_logical_replication_slot('video_slot', 'pgoutput');

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;

CREATE SUBSCRIPTION subscribe_video_db
CONNECTION 'host=db.project.supabase.co port=5432 dbname=postgres user=postgres password=password'
PUBLICATION video_publication;

CREATE SUBSCRIPTION subscribe_video_db
CONNECTION 'host=db.project.supabase.co port=5432 dbname=postgres user=postgres password=password'
PUBLICATION video_publication;

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?

Replicate to another Postgres database using Logical Replication | ...

Example to setup logical replication using publish-subscribe to a Postgres database outside of Supabase

Replicate to another Supabase Instance

Similar Threads

Similar Threads

Similar Threads