How to Create and Connect PostgreSQL with Amazon RDS | S3 CloudHub

foreign welcome back to the S3 cloudhub YouTube channel in this video we will see how we can create a database using RDS or relational database service a service provided by Amazon web services so without any further Ado let's get started the session first of all guys let's see what is RDS so Amazon relational database service or RDS enables developers to create and manage relational databases in the cloud as part of Amazon web services this service can integrate with Amazon's nosql database engine simple DB which supports applications that need relational and non-relational databases it also works with my SQL Oracle and Microsoft SQL for applications that already use these database tools so basically RDS provides you a feature through which you can create a database instance that will be hosted on the virtual private cloud and then in that RDS instance we can create multiple databases as per our requirement here are some of the benefits and features of AWS RDS First Independent scaling then ease of implementation process automation security reliability and availability cost now let's see what is VPC or virtual private cloud a virtual private cloud or VPC is an isolated private Cloud environment typically hosted and secured within another Cloud which is typically a public cloud companies use VPC environments to test and run applications create and maintain databases host and operate websites and for other operations that typically use private clouds so guys now let's create and connect postgres SQL database with AWS RDS so as you can see this is my AWS Management console now here first we will create a security group that defines an inbound rule that will allow access from the internet then we can associate the security group to a database instance so let's search for VPC and here let's click on create Security Group let's give it a name here description now here let's add an inbound rule so in type let's select post gray SQL and here in Source let's select anywhere ipv4 and then the same thing for IPv6 here outbound rules should be good no need to change this in tags also so click on create alright there we go we're able Now to create a security group for our database instance so let's go ahead now and create a postgresql instance using the RDS service so please go to RDS now click on create database here make sure you click on standard create database then the postgresql and here for the version I will go with 13.4 if you go for latest one then you will not able to use the free tier template so here let's select free tier so here let's give it a name now here let's give a password here let's select burstable class and select T2 micro now here for storage select general purpose and make sure you have disabled this Auto scaling and now in connectivity enable Public Access and then select our security group that we have created and now in additional configuration here let's give a name to initial database and then disable this auto backup option the encryption and all this now click on create database so this may take five to ten minutes so as you can see on the screen it's created now now the next thing that we need to do is we need to connect using the PG admin software to this instance so let's click this and here let's copy this endpoint or the address and then let's open up the PG admin I will provide the software Link in the description on my end it's already installed so let's see here here let's click on add new server enter the connection name then click on connection Tab and this is where we put in the endpoint address that we copied here make sure the port is 5432. enter the username and password that you created now click on Save all right so we're able to connect now and let's see if we're able to see the sample DB database here it's successfully loaded so yeah congratulations you're able Now to create a postgresql using the PG admin software I hope you all guys understand the concept so guys that's it for this video I hope you liked it I will see you in the next lecture if you have any question or any doubt feel free to ask in the comment section below I will answer you as soon as I can thank you for watching bye and have a nice day

Channel: S3CloudHub

Views: 24,690

Keywords: aws, rds, relational database service, database, aws tutorial, postgresql, postgressql with rds, what is rds, how rds works

Id: 0A-5ITILrMA

Length: 5min 51sec (351 seconds)

Published: Wed Nov 30 2022