Re:Run PostgreSQL. The Kubernetes Way
by tetha on Friday September 22, 2023 @06:59PM
(#37618890)
Also what about the customer that deleted an important thing 6 weeks ago and absolutely needs it recovered? BTW, it's just one tentant in that DB, the other shouldn't be recovered, naturally.
[ Parent
| on HN ]
Re:Run PostgreSQL. The Kubernetes Way
by aprilllll on Friday September 22, 2023 @07:16PM
(#37619017)
In that case, it’d probably be best to just handle deletions at the application layer (e.g., setting a “deleted_at” timestamp field with scheduled permanent deletions later).
And in terms of data compliance, it’s very important to make sure permanent deletions propagate through your backup systems within a reasonable amount of time - Google Cloud[1], for example, is ~180 days.
[1] https://services.google.com/fh/files/misc/gcp_data_deletion_...