Snapshot Restore versus pg_restore — RDS Disaster Recovery

Image for post
Image for post

Summary

Image for post
Image for post

Analysis

pg_restore

Image for post
Image for post
PGPASSWORD='${PGPASSWORD}' pg_dump -h "restore-test.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.com" -p 54321 XXX XXX - format=c > xxx.sql
Image for post
Image for post
PGPASSWORD=’${PGPASSWORD}’ pg_restore -v -h “restore-test.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.com” -p 5432 XXX -d POSTGRESQL -j 4 -O -C “xxx.sql”
Image for post
Image for post

Snapshot Restore

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Conclusion

Written by

What is hell for Doomguy, is manual work for me (I also hit animal skin stretched over hollow wooden objects to create music 🥁) mertacikportali.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store