Coinhexa/test-rds

Test if RDS works via sequelize

Test RDS

Resources

• Install eslint
• Install prettier, husky
• Install nvm on Amazon Linux 2
• Install nvm on Amazon Linux 2 as user data script does not work but works when run manually
• Install node on Amazon Linux 2
• Use pgpass file
• Streaming PostgreSQL pg_dump to S3
• A Backup Script To Move Redis RDBs and AOF to S3
• Backup MySQL to Amazon S3
• mysql-aws-s3-backup.sh
• Save Amazon ElastiCache Redis to file dump.rdb
• backup-redis
• Bash script to dump and restore postgres DB on another host
• How to copy production database on AWS RDS(postgresql) to local development database
• Hacky AWS ElastiCache Hourly Backup Shell Script
• SSH into ElastiCache - Redis
• pg_dump and upload to S3 using s3cmd
• Database backup/restore via S3

Purpose

• Check if our EC2 instance can connect with RDS

Before running

Log in to postgres instance

psql "host=test-rdsdb.cvagccap4gx8.us-east-1.rds.amazonaws.com port=26189 dbname=postgres user=postgres sslrootcert=/home/ec2-user/test-rds/certs/rds-ca-rsa2048-g1.pem sslmode=verify-full"

Create the sslinfo extension

CREATE EXTENSION sslinfo;

Select the extension which should return true

SELECT ssl_is_used();

How to run

Localhost

POSTGRES_DB=postgres DB_DIALECT=postgres POSTGRES_HOST=localhost POSTGRES_PASSWORD=password POSTGRES_PORT=5432 POSTGRES_SSL=false POSTGRES_USER=vivekramesh node index

AWS

POSTGRES_DB=postgres DB_DIALECT=postgres POSTGRES_HOST=test-rdsdb.cvagccap4gx8.us-east-1.rds.amazonaws.com POSTGRES_PASSWORD=testRDSinstance POSTGRES_PORT=26189 POSTGRES_SSL=true POSTGRES_USER=postgres node index

psql

psql "host=test-rdsdb.cvagccap4gx8.us-east-1.rds.amazonaws.com port=26189 dbname=postgres user=postgres sslrootcert=/home/ec2-user/test-rds/certs/rds-ca-rsa2048-g1.pem sslmode=verify-full"