For this reason, it’s best to set up automation to regularly check the IP of the instance and update your target group accordingly. Warning: The IP address of your RDS instance can change without notice.
Use the IP address from the previous step to register your RDS instance as the target. Set the protocol and port to TCP and 5432.Ĭhoose the same VPC as your RDS instance. Materialize uses PostgreSQL’s logical replication protocol to track changes in your database and propagate them to Materialize.Īs a first step, you need to make sure logical replication is enabled.Īs a user with the rds_superuser role, use psql to connect to your database.Ĭreate a dedicated target group for your RDS instance. Then recreate them after creating new publications for the updated schemas. To handle schema changes, you need to drop the existing sources and Will set the source into an error state if a breaking DDL change is detected Materialize does not support changes to schemas for existing publications, and Make sure there are no schema changes planned or in progress on the tables that you want to replicate.
You’ll use psql to interact with your PostgreSQL database and with Materialize. Make sure psql is installed on your workstation. Make sure you are running a supported version of PostgreSQL.
CREATE VIEW PSQL HOW TO
This page shows you how to stream data from Amazon RDS for PostgreSQL to Materialize using the PostgreSQL source. Ingest-data Ingest data from Amazon RDS
0 kommentar(er)
