How-To-Take-Prod-Dump

Gateway IP : 45.114.245.215
Port : 10443
Username : vasanth
Password: ctrls@%%**

UAT postgres login credentials:
ssh egov@10.0.0.25
password:eGovCtrl7918

DB DUMP IMPORT TO UAT:
1. Ask to Raise a Jira Ticket
2. Connect to cntls server using VPN
3. login in UAT db server
4. cd PROD_DUMPS
5. vi schema_backup_prod.sh
6. edit the schema name
7. run the script (nohup ./schema_backup_prod.sh Jira &)
8. cd sanitize-dbdump-restore
9. vi uat_ulb_format.txt
10. edit: <schemaname>:../<dump file name>
11. perl import.pl -c uat_ulb_format.txt

DB DUMP IMPORT TO AWS APDATALOAD:
1. Ask to Raise a Jira Ticket
2. Connect to cntls server using VPN
3. manju@egov-notebook:~$ ssh <IP> -p <Port>
4. cd PROD_DUMPS
5. vi schema_backup_prod.sh
6. edit the schema name
7. run the script (nohup ./schema_backup_prod.sh Jira &)
8. ls -l
9. tail -f nohup.out
10. get the backup url
11. login to aws server: using .pem file
12. do rsync
13. setting aws date:
> sudo timedatectl set-ntp false
> date --set "01 April 2019"