[Bucardo-general] Usage Help: Postgresql at Amazon RDS to Amazon Redshift

[David Christensen]

Hi Vivek,

I see no reason that syncing to redshift should not work.  You would need a server to run the Bucardo daemon that could access both the PostgreSQL database and the Redshift database.  (Particularly if the Redshift database is just a target and we’re not looking at a multi-master situation, my confidence is higher.)  Is this a regular standalone PostgreSQL instance or are you using RDS?

There are definite limitations when it comes to using Bucardo (much like any tool) so it’s important to understand what its strengths are and where it might not be the best fit.  Bucardo works best when the database schema is fixed, when all tables involved have Primary Keys, and when the write load is not completely saturated.  (There is a write amplification effect due to the fact that Bucardo has to record each row that changes when you modify a row, so every write effectively becomes 2 writes.)

HTH, and feel free to contact us with any issues that may arise.

Best,

David
--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180322/9a8dd4dc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180322/9a8dd4dc/attachment.sig>