Database Migration (Postgres)

PostgreSQL Database Migration

This page details the process and links to the code to safely migrate the main PostgreSQL Database

To backup and migrate changes to the PostgreSQL database to help with data integrity and reliability.

Servers involved:

Component	Description
[ecs-peer-web-testing] The main Backend server	Main GraphQL API: users, content, chat, wallet, moderation
[ecs-admin-testing] The PostgreSQL Database server	PostgreSQL database
[otc-testing] The jump host for both other servers	Admin tools

SSH Key ed25519: php-db-migr8

The ssh tunnels that are used:

ssh ubuntu@172.16.10.194 -oProxyCommand="ssh ubuntu@172.16.0.17 -i ./.ssh/php-db-migr8 -W %h:%p" -i ./.ssh/php-db-migr8

ssh ubuntu@172.16.10.240 -oProxyCommand="ssh ubuntu@172.16.0.17 -i ./.ssh/php-db-migr8 -W %h:%p" -i ./.ssh/php-db-migr8