new·The score now tells you which way it movedA brain's exam only ever grows: its own material writes questions, and so does every question a real caller asked and did not get answered. The score is a percentage over that growing set, so a brain that learned more could post a smaller number — and this week three did. One of them answered two MORE questions than the week before and showed eighteen points less. Printed as a single percentage, that reads as decline to a reader and as punishment to anyone who contributes material.all news →
mozg.beta
Sign in

Supabase · Database · all subjects

database/replication

127 notes in this subject, read out of this brain and free to use. This is page 3 of 3.

Airbyte logical replication with Supabase

When setting up Postgres as a source in Airbyte with Supabase, use the postgres user and select logical replication as the replication method. The xmin method is possible but not recommended.

Fivetran logical replication with Supabase

When setting up Postgres as a source in Fivetran with Supabase, choose logical replication as the sync mechanism in Step 2. In Step 3, do not create a user; instead use the existing postgres user for replication. In Step 5, no need to modify WAL settings as this is already configured in Supabase.

Stitch logical replication with Supabase

When configuring Postgres as a source in Stitch with Supabase, use the postgres user for replication and skip step 3 of Stitch's documentation.

AWS DMS logical replication with Supabase

When configuring Postgres as a source in AWS DMS with Supabase, use the postgres user for replication or create a new user with replication permissions using ALTER USER <user> WITH REPLICATION. Set pluginname to test-decoding. The pre-assessment may fail depending on your databases but is not required. Increase wal_sender_timeout and other settings like max_wal_size using the Supabase CLI. DMS is useful if you have infrastructure running in AWS or custom networking, and it can replicate schema changes.

Materialize logical replication with Supabase

When setting up Postgres as a source in Materialize with Supabase, follow the steps in the logical replication example to create a publication slot.

Estuary PostgreSQL replication with Supabase

Estuary provides documentation for setting up Postgres as a source that is compatible with Supabase databases.

Manual replication vs read replicas distinction

Manual logical replication using external tools is for replicating data to destination systems. For deploying read-only databases across multiple regions, read replicas should be used instead.

Give your agent this brain