How to create AWS rds PostgreSQL Database

In this article, we are going to talk about detailed steps to create an AWS Postgres database instance on AWS cloud. Amazon RDS has two options for PostgreSQL. The first one is the normal AWS Postgres RDS database and Another one is aurora PostgreSQL. AWS Postgres gives you a lot of performance gain and HA options comparing with the normal data center (DC) database. You can get AWS Postgres with few steps. I have mentioned all possible details in the post about AWS PostgreSQL. If you need any AWS PostgreSQL pricing details you can open the AWS calculator portal and can get details about estimated the cost.

In case if you have any question let me know my comments. Let’s start creating an AWS PostgreSQL RDS database instance.

1# Login to AWS console and Search for ‘RDS‘.

#2. Click on create on Database

#3. Select PostgreSQL .

#4. Select the database template. In my case, I have selected ‘Free tier’ you can select ‘Production’ or ‘Dev/Test‘ according to your requirement. Production and Dev/test will not be free from the day one it will be chargeable.

#5. Give some meaningful database name and Master database username with password.

#6. I have selected the free database classes which come with the free tier.

#7. Based on your database storage needs to select the ‘Allocated space’.

#8. If your database is business-critical you can choose a Multi-Availability Zone for database high availability.

#9. Chose the default VPC. If you are configuring it for Production or development chose the appropriate VPC using the dropdown button.

[su_box title=”IMP Note for Additional connectivity configuration” box_color=”#fe2227″ title_color=”#101112″]In case if you like to access the database from your laptop/Desktop. Select the option ‘Publicly Accessible‘ to yes.[/su_box]

#10. Chose the option according to your application and the AWS ecosystem setup.

#11. To enable Cloudwatch logs or backup you can configure ‘Additional configuration‘.

#12. Click on ‘Create Database‘

#13. It will take a few minutes to create database.

#14. You can view the database credentials after clicking on ‘View credentials details‘ .

#15. You will see this message once your database is ready for action.

Please comment if you have any doubt. Like our Facebook page

How to Become Oracle apps DBA?
What does DBA mean?
150 Oracle DBA Interview Questions
Top 5 Future Technologies for Database Administrators (DBA) to learn in 2020
Top 5 Software Technology Trends in 2020 List

Top 5 Software Technology Trends in 2020-List

Here is a list of Top 5 Software Technology Trends in 2020 because as growing professionals we always search for new technologies to learn to boost our career. After great research, we have identified the top best technologies to learn this year i.e. 2020 so if you want to know anything about update your knowledge of future technologies |Latest on Technology Trends |Future Jobs in Demand |Top 5 Growing Jobs | Fastest Growing Careers continue reading.

They are the best technologies in the field of Information technology in 2020. In addition, they are the best technologies to learn for freshers too.

Jobs that are based on these technologies will be in demand in the next 10 years in the world, in short, they are here to stay. Utilize this list of Top 5 Software Technology Trends in 2020 and hope it helps you achieve immense success in the coming year.

1. Top 5 Software Technology Trends in 2020:Artificial Intelligence

First in the list of Top 5 Software Technology Trends in 2020 is Artificial Intelligence ,in very easy terms its human intelligence and has been configured in a machine’s brain or ROM which is programmed to work as a substitute human. It is the best technology to learn in the future. There are a lot of opportunities in the top job portals like dice.com and LinkedIn.com.

Some good books to read on Artificial intelligence

[su_note note_color=” #0074be” text_color=”#fffde7″ radius=”10″]You might be thinking why I am suggesting the books when tons on website and tutorials are available on the web but trust me I still prefer books because they give the information in a structured manner with the sequence. Once you’re done with one book your basics are ready to go for advanced topics that can be learned by various tutorials available on the internet [/su_note]

1. Introducing Artificial Intelligence