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.