Upload PostgreSQL Database to AWS

Question

I have a PostgreSQL database . How I can migrate this to Amazon Web Service RDS??

I don't understand how to do it. Is it using Database Migration Service on AWS?

Can Database Migration Service export local database to Amazon RDS? — Rifat Rahman
– Rifat Rahman, Commented Oct 23, 2017 at 10:04

Sergey Kovalev · Accepted Answer · 2017-10-23 10:07:13Z

5

You can use AWS Database Migration Service, but that seems like an overkill if you migrate from PostgreSQL to PostgreSQL. Database Migration Service allows data migration between different RDBMS and even between NoSQL databases and RDBMS.

Just dump your database with pg_dump and restore it to RDS instance with pg_restore.

answered Oct 23, 2017 at 10:07

Sergey Kovalev

9,4712 gold badges30 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rifat Rahman Over a year ago

I have dumped my database. How do I can restore it with pg_restore on RDS Instance?

Collectives™ on Stack Overflow

Upload PostgreSQL Database to AWS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related