RDS to S3 using pg_dump directly (without intermediary)

Question

It's possible to run pg_dump in the RDS or in an S3 (without using an intermediary like ec2 to execute the command)

Answer 1

You should be able to access it as long as your db security group allows external access to port 5432 (default for Postgres). Then you can just run:

pg_dump -h <database_host> -U <username> <database>

Keep in mind that your connection will not be encrypted. Also, there is no interface for connecting S3 and RDS, so you would have to set up a data transfer separately.