Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in AWS by (19.1k 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.4k 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.

Related questions

0 votes
1 answer
Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...