Putem face drop unei baze de date psql din RDS dupa cum urmeaza:

Conectare la RDS (Important - ne conectam la alt db decat cel pe care vrem sa-l stergem)

psql -h my-db.rds.amazonaws.com -U user posgres

Inchide conexiunile active:

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'my_database'
  AND pid <> pg_backend_pid();

Drop db:

drop database my_database