FAQs
Which connection string should be used?
Always use the direct connection string for logical replication.
Connections through a pooler, such as Supavisor, will not work.
The tool in use does not support IPv6
You can enable the IPv4 add-on for your project.
What is XMIN and should it be used?
Xmin is a different form of replication from logical replication and should only be used if logical replication is not available for your database (i.e. older versions of Postgres).
Xmin performs replication by checking the xmin system column and determining if that row has already been synchronized.
It does not capture deletion of data and is not recommended, particularly for larger databases.
Can replication be configured in the Dashboard?
You can view publications in the Dashboard but all steps to configure replication must be done using the SQL Editor or a CLI tool of your choice.
How to configure database settings for replication?
Yes. Using the Supabase CLI, you can configure database settings to optimize them for your replication needs. These values can vary depending on the activity of your database size and activity.
What are some important configuration options?
Some of the more important options to be aware of are:
max_wal_sizemax_slot_wal_keep_sizewal_keep_sizemax_wal_senders