User Migration Prod Go Live

  1. Login psql
sudo -u postgres psql
  1. Renambe to back if exist
ALTER DATABASE rtvm RENAME TO rtvm_backup_1;

Remove SET transaction_timeout line

sed -i '/SET transaction_timeout/d' kkr-rtvmdb-202601300827.sql

Remove LOCALE_PROVIDER clause from CREATE DATABASE

sed -i 's/LOCALE_PROVIDER = [^ ]* //' kkr-rtvmdb-202601300827.sql

Revision #1
Created 31 March 2026 07:52:31 by Admin
Updated 1 April 2026 07:50:31 by Admin