Restoring a gzipped SQL dump

restoration from gzipped SQL dump

# First get the file:

scp ubuntu@10.0.1.120:~/rds_backups/backup-2017-08-27.sql.gz ./

# Drop and create the template database:

sudo -u postgres dropdb aya_prod && sudo -u postgres createdb aya_prod

# Copy it to the virtual disk, then create a new database with it:

gunzip < database.sql.gz | sudo -u aya psql aya_prod 

# As long as that goes well, drop and create the production database using the template database

sudo -u postgres dropdb aya
sudo -u postgres psql
> CREATE DATABASE aya WITH TEMPLATE aya_prod OWNER aya ENCODING='UTF8';

# And you're finished!