[HACKERS] Review of DDL replication solution - Mailing list pgsql-hackers

From Jeremy Finzel
Subject [HACKERS] Review of DDL replication solution
Date
Msg-id CAMa1XUgEjn1B6CfbQGZ5zUietmnVv_vEqqs-fHnr=fdqapC+qg@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hello!

I am new to Postgres backend development, and have created a recent project that has minimal C code.  It is a transparent DDL replication solution built on top of pglogical, but with a concept that could be used also with other logical replication solutions if they support some mechanism to propagate SQL to subscribers.  I describe some of its limitations in the docs:

I would greatly appreciate some critique/review of the C code in particular: https://github.com/enova/pgl_ddl_deploy/blob/master/pgl_ddl_deploy.c

It is extremely simple and most of the code is shared from other existing Postgres code.  But if we put this into production, I'd love for some more experienced devs to at least take a look at it.

Likewise, I would love if in general anyone would try to see if using this is feasible in their environment.

I have posted already on the bdr/pglogical list, but would also like to share this with the broader community.

I appreciate all positive/negative feedback.  Cheers!

Jeremy Finzel
(DBA at Enova International)

pgsql-hackers by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: [HACKERS] parallelize queries containing initplans
Next
From: Haribabu Kommi
Date:
Subject: Re: [HACKERS] parallelize queries containing initplans