Re: Support logical replication of DDLs - Mailing list pgsql-hackers

From Zheng Li
Subject Re: Support logical replication of DDLs
Date
Msg-id CAAD30UKtDOmjMOyXG6bhpKj9eswQ31scPR50Ne37AfUfEhKb8A@mail.gmail.com
Whole thread Raw
In response to Re: Support logical replication of DDLs  ("Euler Taveira" <euler@eulerto.com>)
List pgsql-hackers
> I'm planning to work on the initial DDL replication. I'll open a new thread as
> soon as I write a design for it. Just as an example, the pglogical approach is
> to use pg_dump behind the scenes to provide the schema [1]. It is a reasonable
> approach but an optimal solution should be an API to provide the initial DDL
> commands. I mean the main point of this feature is to have an API to create an
> object that the logical replication can use it for initial schema
> synchronization. This "DDL to create an object" was already discussed in the
> past [2].

Nice! I think automatic initial schema synchronization for replication
is a very useful feature.

Regards,
Zheng



pgsql-hackers by date:

Previous
From: "Euler Taveira"
Date:
Subject: Re: PG DOCS - logical replication filtering
Next
From: Robert Haas
Date:
Subject: Re: typos