database migration for qa

[kayiwa]

database dump

• stop webserver connections

  sudo systemctl stop nginx

• drop database

  pg_dump --format custom --clean --no-owner --no-privileges cdh_geniza > 2023_10_25_cdh_geniza.dump

• transfer database (as pulsys)

  sudo mv /var/lib/postgresql/2023_10_25_cdh_geniza.dump .
  scp 2023_10_25_cdh_geniza.dump lib-postgres-prod1:~

• run a db_setup playbook
• import database from new host

  sudo mv 2023_10_25_cdh_geniza.dump /var/lib/postgresql
  pg_restore -h 127.0.0.1 -U cdh_geniza --dbname cdh_geniza --no-owner --no-privileges 2023_10_25_cdh_geniza.dump

• restart webserver connection

  sudo systemctl start nginx

[rlskoeser]

@kayiwa is there anything we should document here before we close this issue?

[rlskoeser]

this was completed in November