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

[@amitpatil4771]

Great explanation of backup and restore of Postgres

[@sunilkumarshetty9148]

great , helped me Sir thank you.

[@joelletchaks4570]

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

[@JuanCruz-qc9ms]

Thanks very much, greetings from argentina!

[@srkkhan5867]

Thanks alot for the video it was really helpful 😊

[@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

[@sunilkumarshetty9148]

you have MS SQL on-premise to AWS Postgres migration video by any chance

[@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

[@joaomoreira1829]

Great work, thanks

[@malithjayalath6417]

Worked thank you very much

[@Rickeless]

I would suggest using custom tcp and setting it to your IP instead

[@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

[@mujtabahassan3553]

im getting ssl error have you disabled it in this video?

[@psyferinc.3573]

thank you

[@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 ?...

[@jintuthomas6947]

Is That database is stored in aws????

[@sandeepsahu1716]

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

[@faisalkhan-gy5ef]

Do we don't have to run migrations?

[@yashdholakia6201]

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

[@luv-ly462]

i keep getting connection time out bruhh

[@flutterguru3764]

Migrate local mysql database to aws