Advice for tools to sync from one Postgres instance to Parade instance

[salieflewis]

Not super familiar with this process. It seems like there are tools like this built into Elasticsearch, but not really sure how to do it aside from a more manual process.

Feel like I read that a Parade instance could also double as your source of truth database, but I'm also not super keen on the sound of that. Open to changing my mind.

Appreciate any recommendations! Thanks.

[philippemnoel]

Not super familiar with this process. It seems like there are tools like this built into Elasticsearch, but not really sure how to do it aside from a more manual process.

Feel like I read that a Parade instance could also double as your source of truth database, but I'm also not super keen on the sound of that. Open to changing my mind.

Appreciate any recommendations! Thanks.

Hi @salieflewis. We don't suggest using ParadeDB as a source of truth, but rather colocating it with your source of truth Postgres. This involves connecting your primary Postgres, say RDS, to ParadeDB deployed in your infrastructure via logical (streaming) replication.

At this time, it is a manual process. But, we're currently working on enabling this seamlessly! If this is interesting to you, please email me at [email protected] and we can get you early access to this functionality once it is ready in a few weeks.