Skip to main content
This is a guide on how to create a Supabase PostgreSQL peer which you can use for replication in PeerDB.
PeerDB Cloud supports Supabase via IPv6 natively for seemless replication.
1

Creating a user with permissions and replication slot

Let’s create a new user for PeerDB with the necessary permissions suitable for CDC, and also create a publication that we’ll use for replication. For this, you can head over to the SQL Editor for your Supabase Project.
  1. Create a dedicated user for PeerDB:
  2. Grant schema-level, read-only access to the user you created in the previous step. The following example shows permissions for the public schema. Repeat these commands for each schema containing tables you want to replicate:
  3. Grant replication privileges to the user:
  4. Create a publication with the tables you want to replicate. We strongly recommend only including the tables you need in the publication to avoid performance overhead.
    Any table included in the publication must either have a primary key defined or have its replica identity configured to FULL.
    1. To create a publication for specific tables:
    1. To create a publication for all tables in a specific schema:
    The peerdb_publication publication will contain the set of change events generated from the specified tables, and will later be used to create the MIRROR (replication).

User and publication commands

Click on Run to have a publication and a user ready.
The PeerDB user must not be restricted by RLS policies, as it can lead to missing data. You can disable RLS policies for the user by running the below command:
Make sure to replace peerdb_user and peerdb_password with your desired username and password.Also, remember to use the same publication name when creating the mirror in PeerDB.
2

Create the Supabase Peer on PeerDB OSS

  1. Head over to your Supabase Project’s Project Settings -> Database (under Configuration).
Important: Disable Display connection pooler on this page and head over to the Connection parameters section and note/copy the parameters.

Create the Supabase Peer

  1. Head over to PeerDB UI and click on Create Peer. Select Postgres as the source.
  2. Now you can fill in the connection details you copied earlier, but make sure to use the username and password you created earlier in the SQL Editor in Step 1.

Create the Supabase Peer

  1. Click on Validate and once that’s green, you can go ahead and click on Create to create the peer!
3

Increase max_slot_wal_keep_size

This is a recommended configuration change to ensure that large transactions/commits do not cause the replication slot to be dropped.
This step will restart your Supabase database and may cause a brief downtime.
You can increase the max_slot_wal_keep_size parameter for your Supabase database to a higher value (at least 100GB or 102400) by following the Supabase DocsFor better recommendation of this value you can contact the PeerDB team.
When creating the Mirror, make sure to reuse the same publication you created earlier in Step 1