0 votes
1 view
in AWS by (19.2k points)

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

1 Answer

0 votes
by (44.6k points)

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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !