Remove `meilisync` as an option to sync PostgreSQL

[omar-zahid]

meilisync is suggested as a way to sync data between Postgresql and meilisearch. This wrongly implies meilisync as an official adapter from meilisearch. To make things worse, this app is buggy (at least for PG) and causes errors in production.

Here is the documentation in question: https://www.meilisearch.com/docs/guides/database/meilisync_postgresql

Here are the open issues in meilisync related to postgres.

long2ice/meilisync#68
long2ice/meilisync#111
long2ice/meilisync#37
long2ice/meilisync#28

For us, we've encountered production outage due to WAL errors and our storage spiked to 100% due to the replication slot errors.

Please consider removing meilisync from the documentation at least until the issues above are addressed and the app is stable. Thank you.

[guimachiavelli]

Thanks for the feedback, @omar-zahid. We have been getting more and more reports of users experiencing similar issues. We were already seriously considering removing meilisync content from the docs and your report sort of seals the deal for me.

@Strift, I think we should go ahead and remove both the Postgre and the MySQL meilisync guides. I know we don't have a suitable alternative, but at this point I think it's best to have nothing than something that actively harms users. Are you ok with that?

[Strift]

@guimachiavelli, I agree.

But these guides are also featured in Meilisearch Cloud, so we need to validate this with @meilisearch/product-team.

[macraig]

I think this makes sense, @gmourier do you agree? If so we can ask the Cloud team to remove any mentions on the Cloud

[Strift]

Note: we have external articles linking to our meilisync guides, e.g. this piece. We'll need to think of a redirection for this links.

I think redirecting to meilisync repo would be good enough, and better than a 404. Not feeling strongly this either, so happy to go in another direction.

[gmourier]

I think redirecting to meilisync repo would be good enough, and better than a 404

Agree

[Strift]

Hi @meilisearch/product-team @guimachiavelli,

Looks like @mdubus already removed this from the Cloud in August: https://github.com/meilisearch/meilisearch-cloud/issues/5082

We should be free to proceed :)

[ohld]

Great idea, guys!

But how then I should sync MeiliSearch db with a table in Postgres?

[guimachiavelli]

Hello @ohld!

This issue is about the removal of meilisync content from the official documentation due to users reporting too many issues with that tool. We do plan to provide more content on database migration in the future, but we're still in the early stages of discussing what should be our official guidance on the matter.

For a more immediate solution, I'd recommend reaching out to our support staff and the community on Meilisearch's official Discord server. You're much more likely to get timely and useful help there.