Skip to main content

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
No Comments
Back to top