Detecting schema changes via WAL logs - Mailing list pgsql-general

From Cal Mitchell
Subject Detecting schema changes via WAL logs
Date
Msg-id C90BBBF0-F41A-43D0-8988-E4964B31D75F@sqlpipe.com
Whole thread Raw
Responses Re: Detecting schema changes via WAL logs  (Tomas Pospisek <tpo2@sourcepole.ch>)
List pgsql-general
Hello everyone,

I’m building an open-source data integration tool (SQLpipe) and am now trying to incorporate CDC into the product.

Is it possible to detect when schema changes happen via the WAL? The WAL doesn’t have to tell me what was changed, it just needs to tell me when something changed.

For example, anytime I run create table or some other DDL command, there is a begin and commit message in the log, with nothing in between. If there aren’t any other operations that create such “empty” logs, it seems possible to just re-scan the tables that are being synced for schema changes whenever one of these logs is encountered.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Strange results when casting string to double
Next
From: Carsten Klein
Date:
Subject: Re: Strange results when casting string to double