By Morgan Lucas Had a fair amount of help with this with one of the startups I work for. It takes a village and all.

I was tasked with checking restore speeds for a PostGRES Database that was hosted on an AWS Instance.

Why Would We Want to Restore a PostGRES Database?

What if someone accidentally deletes everything? We can bring it back to a point in the past - provided we’ve done backups.

How big were the file sizes?

About 10 GB.

<aside> 💡 You can put time in front of a command to see how long it takes, down to milliseconds!

</aside>

• initially tried with an SSH tunnel (secure tunnel to connect to a machine). I had to connect to one VM (VM-A) and then, within that VM, connect to the DB (DB-A).
• I had a .pem key that was used to get into VM-A, as the relevant information to get into DB-A was on VM-A.
• pg_restore was an option, but I used psql:

How to actually upload to DB-A while in VM-A:

psql --host=rdstemplate-test.[rm].us-west-2.rds.amazonaws.com --username=test --dbname=postgres --password < demo-big-en-20125562.sql

One could also use pg_restore

We made sure the databases existed with \\land dropped and created with drop database [NAME] and create database [NAME]

<aside> 💡 Some errors may still show up, even if the information is pushed to the database.

</aside>