Learn how to connect Fivetran with your Aptible Databases
⚠️ Prerequisites: A Fivetran account with the role to Create DestinationsTo connect your existing Aptible PostgreSQL Database to Fivetran: Step 1: Configure Fivetran Follow Fivetran’s General PostgreSQL Guide, noting the following:
pgoutput
is the preferred method. All PostgreSQL databases version 10+ have this as the default logical replication plugin.
wal_level
and max_replication_slots
settings will already be present on your Aptible PostgreSQL database
max_replication_slots
is 10. You may need to increase this if you have many Aptible replicas or 3rd party replication using the allotted replication slots.pg_hba.conf
file can be skipped, as the settings Aptible sets for you are sufficient to allow a connection/authentication.
wal_sender_timeout
, so you’ll likely have to run ALTER SYSTEM SET wal_sender_timeout 0;
or something similar, see related guide: How to configure Aptible PostgreSQL Databases
⚠️ Prerequisites: A Fivetran account with the role to Create DestinationsTo connect your existing Aptible MySQL Database to Fivetran: Step 1: Configure Fivetran Follow Fivetran’s General MySQL Guide, noting the following: