Aurora PostgreSQL Reader endpoint as Source

ranga — Mon, 03 Oct 2022 18:59:32 GMT

Currently we are replicating data from

Source DB: Amazon Aurora Postgres Version 13.6

Target DB: Amazon Aurora Postgres Version 13.6

Would like to confirm if we can use Source DB Reader Endpoint rather than using Writer Endpoint( As there will be one write and multiple readers).

We are aware that it creates replication slot and that requires Writer Endpoint and would like to confirm if they are any workarounds?

Thanks,

Ranga

Re: Aurora PostgreSQL Reader endpoint as Source

Pedro_Lopez — Thu, 06 Oct 2022 07:06:09 GMT

Hello Ranga,

First I'd like to bring to the attention that native Amazon Aurora PostgreSQL is currently only supported as a Source and in order to use as a target it has to be used through the MySQL endpoint, is this your case?

Consequently, yes you can use the Source DB Reader Endpoint rather than using Writer Endpoint in Replicate's Source Amazon Aurora PostgreSQL.

Now regarding the writer endpoint, this would apply if you have a PostgreSQL based endpoint as the Target. Could you elaborate more on what kind of workaround you're mentioning? What is the goal trying to achieved?

Regards,
Pedro

topic Re: Aurora PostgreSQL Reader endpoint as Source in Qlik Replicate

Aurora PostgreSQL Reader endpoint as Source

Re: Aurora PostgreSQL Reader endpoint as Source