*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Here are the details of the process that was followed to replace the user_id field on historic loan rows with NULL on Friday, May 9
| Step | Status | |||
|---|---|---|---|---|
| 1 | The hosting team will keep the backup to Cornell's Metadb reporting database that is taken right before the anonymization process is run. Backups are incremental and are made on a rolling basis by the AWS Managed Service you use for Postgres databases. Backups can be kept for 7 days. | 2 | As specified in the Metadb documentation, the hosting team will stop the server to prevent it from operating with an out-of-date cache. | |
| 32 | The hosting team will run the 2 5 anonymization scripts on the loan and requester tables in the Metadb reporting database. | |||
| 43 | As specified in the Metadb documentation, the hosting team will restart the server | |||
| 54 | The hosting team will inform Sharon when the Steps 2 and 3 are complete. | |||
| 65 | Sharon and Joanne will verify that the loan anonymization process has been successful and that normal data synchronization is continuing through test scripts that capture data stamps in loan_id rows. |
...
Is it possible to keep the backup taken right before the anonymization process is run?
YES. This has been requested as part of the historic loan data anonymization procedureThe backups are incremental, so taking a secondary snapshot backup is not needed.
How long can the backups be saved?
...