How to Migrate Local PostgreSQL Database to AWS RDS

In this video we are going to see how to Migrate local PostgreSQL database to AWS-RDS So this is the 3rd video of MEAN stack deployment architecture for aws
In the last video we have seen that how to deploy nodejs REST APIs to aws Lambda function
So this video is only about AWS-RDS services
RDS has free-tier option with 20GB of storage and 20GB of backup so basically we are going to get RDS service free for one year.
So before starting this video we need pgAdmin
pgAdmin is a database management tool.
so we will use this tool to connect to local postgres databse as well as for Remote Database Service
www.pgadmin.or...
#PostgreSQL #aws #RDS

[@joelletchaks4570]

never thought it could be this easy thank you so much.

[@amitpatil4771]

Great explanation of backup and restore of Postgres

[@sebashmh]

Thanks for the explanation. I understand this is a demo for testing purposes, but be aware it is really dangerous to enable "All Traffic" in the security groups, this is a sure way to get hacked.

[@shriramvenu]

yea. ideally the DB should not be accessible from the open internet. one should restrict it to VPC only and VPN in. but for temporary access, whitelist your ip and then remove it once done

[@JuanCruz-qc9ms]

Thanks very much, greetings from argentina!

[@syedrahatali2309]

nice explanation man, i was already using backup purposes but does't restored using this actually i was using simple file format but in restore the only option is custom this demo solves the problem when i changes the backup to custom

[@srkkhan5867]

Thanks alot for the video it was really helpful 😊

[@malithjayalath6417]

Worked thank you very much

[@joaomoreira1829]

Great work, thanks

[@psyferinc.3573]

thank you

[@aogunnaike]

Awesome thanks

[@AzharKhan-wn8wy]

Thanks 👍

[@jerrychuang81]

How to delete table?I tried to delete one table but it shows the database is locked. I can only delete the row of the table one by one

[@sandeepsahu1716]

Hi sir, can u please help in how to do major version upgrade of postgres SQL version of Amazon rds database

[@lonewolf796]

Why I can't connect with my IP option , anywhere is not secure for prod

[@shriramvenu]

you can

[@lonewolf796]

@@shriramvenu I m using free tier , and trying to connect to local postgresql instance - RDS with only my ip allowed.. security group ?...

[@yashdholakia6201]

(School management system) project ka 1k video create kro plz

[@faisalkhan-gy5ef]

Do we don't have to run migrations?

[@jintuthomas6947]

Is That database is stored in aws????

[@luv-ly462]

i keep getting connection time out bruhh

[@flutterguru3764]

Migrate local mysql database to aws