SupabaseS
Supabase•9mo ago
oof2win2

issues creating a replication slot

hi. i'm trying to create a replication slot to copy my data to another postgres db without having major downtime or having stale data. i chose to use pg replication as in the guide below. the issue is that when i create the subscription on the remote db, i get the following error. how can i debug this issue?
Query 1 ERROR at Line 1: : ERROR:  could not connect to the publisher: connection to server at "db.xxxx.supabase.co" (xx.xx.xx.xx), port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?


https://supabase.com/docs/guides/database/postgres/setup-replication-external
Was this page helpful?