Page History

...

How often are backups made, how are they made, are the historical data backups overwritten with each new backup, are backups incremental or full?

Backups are incremental and are made on a rolling basis - they are made by the AWS Managed Service that the hosting team uses for Postgres databases. 

Is it possible to keep the backup taken right before the anonymization process is run?

...

-need to review tables that keep patron data in this area

-folio_email... etc.

Purge Scripts

These are the 

UPDATE folio_circulation.loan__t__
SET user_id = NULL
WHERE __current = FALSE
  AND user_id IS NOT NULL
;

UPDATE folio_circulation.loan__ AS ln
SET jsonb = jsonb_set(ln.jsonb, '{userId}', 'null'::jsonb, true)
WHERE
  __current = FALSE

;

Questions

What is in the zzz_ tables in Metadb?  e.g., zzz___loan__t___

...