citus icon indicating copy to clipboard operation
citus copied to clipboard

Data loss after changing replication factor

Open niknikhil025 opened this issue 1 year ago • 3 comments

We lost a lot of data after changing the replication factor in the citus cluster. The data added few days before changing the replication factor is lost.

niknikhil025 avatar Feb 12 '24 09:02 niknikhil025

earlier we changed from 1 to 2. Then we changed back from 2 to 1

niknikhil025 avatar Feb 12 '24 09:02 niknikhil025

That sounds really bad. Could you share the steps how you changed the replication factor? Do note that these days a replication factor of greater than 1 is generally not recommended, the functionality is mostly still there for backwards compatibility.

JelteF avatar Feb 12 '24 09:02 JelteF

we changed in postgresql.conf and restarted the postgresql service on all nodes

niknikhil025 avatar Feb 12 '24 10:02 niknikhil025