Using Automatic DDL Replication with pgEdge Distributed PostgreSQL
Until now, managing and updating Data Definition Language (DDL) schemas in PostgreSQL was a time-consuming, manual effort and especially difficult in a distributed environment. With the introduction of automatic DDL replication, pgEdge makes it easier and faster to deliver distributed applications built on open, standard-based PostgreSQL. In this blog, we delve into what Automatic DDL replication entails and how it can be leveraged effectively with pgEdge.
First, let's unpack what DDL commands entail. DDL, or Data Definition Language, encompasses those statements responsible for creating and modifying database objects within PostgreSQL, including tables, indexes, views, and constraints. Commands such as CREATE, ALTER, and DROP fall into this category. On the other hand, Data Manipulation Language (DML) commands focus on operations performed on the data within these objects, such as SELECT, INSERT, UPDATE, and DELETE.
Traditionally, logical replication in PostgreSQL primarily facilitated the replication of DML statements, leaving DDL commands requiring manual intervention. This meant that any modifications to the database schema required manual execution of DDL commands on each node in the cluster—a cumbersome and error-prone process.
