![]() ![]() It is the most powerful and trusted open source database and in terms of backup options, we can use the built-in tool or operating system level options. PostgreSQL provides several options for backups in necessary formats and automation. You might be required to keep backup copies of your data in order to ensure that any changes can be tracked/ reverted over that period. Compliance requirements and Retention Policies: Depending on your industry type, you may need to retain or store data for a certain period of time in order to stay compliant.It could be an operating system issue or even a network transfer issue that can lead to missing bits or bytes, then unexpected results. Software Errors: There will always be a bug here or there at any level of the software being engaged.Despite numerous precautions, there can always be a slip that can put you in a tight spot. Try running a drop table command and then stop it from replicating. Human Error: This one spreads quickly across replicas.This can lead to unavailability of the whole datacentre which leads into all running instances being unavailable, and would require the cluster to be rebuilt from a backup. Device Failure: This is a very common situation. ![]() Even if you have multiple replicas available it is very likely that the corruption can spread (much quicker than you think) across the replicas making them redundant for running any kind of production.
0 Comments
Leave a Reply. |