Skip to main content

Documentation Index

Fetch the complete documentation index at: https://artie.com/docs/llms.txt

Use this file to discover all available pages before exploring further.

​
Enable IPv4 address

To do this:
1
Go to your project settings in Supabase
2
Click on Add Ons
3
Enable Dedicated IPv4 address
Supabase IPv4 Add on

​
Supabase connection string

For logical replication to work, we’ll need a direct connection to the database without the connection pooler. To find your connection string, go to your connection page and click “Direct connection string”.
Supabase connection string

If that’s configured to be your default setting, click “Get connected” to get an expanded view, then make sure it’s configured for a “Direct connection”.
Supabase direct connection

​
To create a service account, run this in Supabase:

CREATE USER artie_transfer WITH PASSWORD 'password';

-- Grant replication permissions
ALTER USER artie_transfer REPLICATION;

-- Grant access to existing tables
GRANT SELECT ON ALL TABLES IN SCHEMA public TO artie_transfer;

-- Grant read-only access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO artie_transfer;

CREATE PUBLICATION dbz_publication FOR ALL TABLES WITH (publish_via_partition_root = true);