Re: [ADMIN] Data replication to PostgreSQL

Hmmm... I suppose that would depend what your Salesforce db is. This may not be the appropriate forum for this question, as PostgreSQL could certainly support all DDL changes. With no experience for Salesforce, I'm at loss to tell you what you would need.
--

Jay

On Thu, Dec 29, 2016 at 10:46 AM, Ram DBA <postgresdbas@gmail.com> wrote:

Hello John,

Thank you for the reply. Our requirement is to copy the data from Salesforce to our local PostgreSQL database for which we had to rely on 3rd party tools. But because of dynamic nature from application, the back-end tables in Salesforce are being changed frequently thus stalling the data replication to PostgreSQL.

Is there any tool that also capture and replay DDL changes from Salesforce to PostgreSQL.

Hope I am clear with the details now, kindly let me know in case of further questions.

Thank you in advance,

Ram

On Thu, Dec 29, 2016 at 8:42 PM, John Scalia <jayknowsunix@gmail.com> wrote:

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