Re: [ADMIN] Data replication to PostgreSQL - Mailing list pgsql-admin

From John Scalia
Subject Re: [ADMIN] Data replication to PostgreSQL
Date
Msg-id CABzCKRC-_DCv72+gvOAsH8-25cD=WrxOKdy7yz+RHcy+-p-ohA@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Data replication to PostgreSQL  (Ram DBA <postgresdbas@gmail.com>)
Responses Re: [ADMIN] Data replication to PostgreSQL  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
I'm not sure I understand what you're doing. Nearly all DDL is written to the WAL segments. The only ones that aren't are things like unlogged and temporary tables. I don't think temporary tables used by queries are written either. Why do you think, however, that this isn't captured?
--
Jay

On Thu, Dec 29, 2016 at 9:35 AM, Ram DBA <postgresdbas@gmail.com> wrote:
Hi team,

We have an use case to copy the data from Salesforce to PostgreSQL environment but because of DDL changes that can happen to tables from Salesforce application side, replication would eventually fail. Do we have any open source tools that can also capture the DDL changes and replicate to PostgreSQL?


Thank you in advance,
Ram

pgsql-admin by date:

Previous
From: Ram DBA
Date:
Subject: [ADMIN] Data replication to PostgreSQL
Next
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] Data replication to PostgreSQL