<div dir="ltr"><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:0px 0px 1.25em;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Hey -</p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:0px 0px 1.25em;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Bucardo is a valuable tool we're using to migrate three Postgres databases from one AWS RDS host to a single Postgres database. Our aim is to consolidate these databases into one, organizing them into unique schemas for each database's tables. We've utilized Bucardo's 'customname' feature for unique schema mapping during synchronization. However, Bucardo checks for matching source and target schemas during validation, leading to issues since our three source databases have differing schemas. Our current workaround involves maintaining a schema ('public') that matches the source alongside the custom schema. Additionally, we've encountered a problem where Bucardo migrates data to both the 'public' and the new 'customname' schema when multiple syncs are configured & enabled. </p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Is there a way to effectively run multiple synchronizations to consolidate three databases into one, while keeping them separated by unique schemas?</p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Example-</p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px"><u>Source DB (3 separate DBs):</u></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px"><i>DB.Schema.Table</i></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">apple.public.<table></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">pear.public.<table></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">mango.public.<table></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px"><u>Target DB ( 1 DB )</u></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px"><i>DB.Schema.Table</i></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Fruits.apple.<table></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Fruits.pear.<table></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Fruits.mango.<table></p><p style="border:0px solid rgb(227,227,227);box-sizing:border-box;margin:1.25em 0px 0px;color:rgb(13,13,13);font-family:Söhne,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Ubuntu,Cantarell,"Noto Sans",sans-serif,"Helvetica Neue",Arial,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Thank you!</p></div>

<br>
<div><hr></div><font face="Arial, Helvetica, sans-serif"><span style="font-size:13px">The information herein is intended for the person or entity to which it has been addressed. This document may contain proprietary, business-confidential and/or privileged material. Any unauthorized use, review, transmission, distribution, reproduction is strictly prohibited.</span></font>