Page History

NASD Tickets

•  Add public key(s) to SSH bastion (NASD-885)
•  Ensure bastion has been whitelisted as part of inflation process
•  Create CloudFront distributions for S3 and API Gateway (NASD-596)
•  Create database dump from NGAP 1.x and store the dump in S3 (NASD-894)
•  Prep resources for DNS switch
  •  Ensure EI team has appropriate tickets
  •  Schedule DDI
  •  Provide EI and DDI team with CNAME

Bamboo

•  Update the configuration to use the script within the repository for deployment (copy from SIT or UAT, they are the same)
•  Ensure necessary variables are set.
•  Deploy a release from UAT to create the API Gateway

Earthdata Login

•  Update application callback URLs with the CloudFront Distribution for API Gateway

Data Migration

•  Create jump box to access our RDS
•  Install Postgres on the Jump box

sudo amazon-linux-extras install postgresql10

•  Run migration script
•  Export migrated data to a file

pg_dump --exclude-table=colormaps --disable-triggers --data-only DATABASE_TO_EXPORT > FILENAME_TO_EXPORT_TO.sql

•  Create an empty database locally
•  Run EDSC 2.0 migrations against the new database to replicate the state of a new database
•  Import the file created above into this database to test the import that will run in production

psql --host RDS_ENDPOINT --port 5432 --username edsc --password --dbname edsc_prod < FILENAME_TO_IMPORT.sql

Day of Data Migration

•  Get new data dump from production
•  Run migration script against any new data
•  Export migrated data to a file
•  Create an empty database locally
•  Run EDSC 2.0 migrations against the new database to replicate the state of a new database
•  Import the file created above into this database to test the import that will run in production
•  Import the data into production via jump box

DNS

•  Request DNS updates to be made