- Connect to remote psql shell
psql --host=<DB_HOST> --port=5432 --username=<DB_USER> --dbname=postgres
- Enter db password if prompted
DROP DATABASE <DB_NAME>;
CREATE DATABASE <DB_NAME>;
Note: This assumes AWS VPC does not block the connection. Check to ensure that you have access through this port.