Databases - MirgDenis/scripts GitHub Wiki
If databases deployed in k8s, check livenessProbe. Termination of connections and revoking access can cause pod fail.
# Terminate connections to database, except your connection
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = '<db_name>';
# Remove connection access (optional)
REVOKE CONNECT ON DATABASE <db_name> FROM PUBLIC, <db_user>;
# Delete DB to avoid conflicts with already created tables
DROP DATABASE <db_name>;
# Create DB
CREATE DATABASE <db_name>;
# From source DB execute following command to migrate DB
pg_dump -C -h localhost -U <db_user> <db_name> | psql -h <remote_address> -U <db_user> <db_name>