Here's what we need:
- Specify what (if any) new columns and tables may be needed in pgehres, and make the changes
- Create a database for ingressing test data during an initial testing phase
- Ensure a seamless switchover from the current pipeline to the new data from EventLogging
Let's plan here the exact SQL commands to run and plan exactly how and when to run them.
- No data loss or corruption due to switchover.
- Existing tools used on the production database should work without changes.