A Step-by-Step Guide to Setting Up a PostgreSQL Database on Amazon AWS
Tags: postgressql, aws, webdev, database
Published: 2023-11-08 14:05:20

Are you looking to set up a PostgreSQL database on Amazon AWS? Follow these simple steps to get started.

Step 1: Sign in to Your Account.
- Begin by signing in to your Amazon AWS account. If you don't have an account yet, you can sign up for one.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fp3c755xeovkeibz2oio.png)

Step 2: Navigate to the Search Bar and Type "RDS"
- Once you're logged in, go to the search bar and type "RDS" to access the Amazon RDS (Relational Database Service) console.

Step 3: Click on the First Option.
- From the search results, click on the first option to access the RDS dashboard.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7a9qe6qb9vtkikxral2r.png)


Step 4: Access Databases in the Left Sidebar.
- On the next page, locate the left sidebar and click on the "Databases" option.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/blyz4me7rxdfrkcj8t45.png)

Step 5: Create a Database.
- Click on the "Create Database" button to initiate the database creation process.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fykfhvhck7cpwvkiuu6a.png)

Step 6: Choose a Database Creation Method >> Standard Create

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/h2gxzarvnnpwou04qhnr.png)


Under "Choose Database Creation Method," select "Create Database."


Step 7: Select PostgreSQL as Engine

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/asuq7hkgqd67wufpiqbt.png)

Under Engine options, choose "PostgreSQL" as the database engine. Leave engine Version as default.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/t82isxep6ozrwbok09au.png)

Step 8: Choose a Free Tier Template
- Scroll down to the Templates section and select "Free tier" for testing or personal projects to avoid unnecessary charges.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pcb0zecyye3qz3kig2i8.png)

Step 9: Configure Name and Password
- Enter the necessary details like Name and Password for your database.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dxreswyal2x8ngopimuk.png)



Step 10: Leave Instance Configuration as Default
- Leave the Instance Configuration settings as default.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/94op61axqtbrq4blzo59.png)



Step 11: Leave Storage Settings as Default.
- Keep the Storage settings as default.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kuusz1u8fg0vpugbe0rx.png)



Step 12: Configure Connectivity and Port.
- Leave connectivity as default, but remember to configure public access. Specify the port number under Additional Configurations.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lnr5rmsk3x7qv02gy48r.png)



Step 13: Leave VPC Security Groups as Defaults
- Keep the VPC Security groups as default.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6pjqbvm2khd1tbj8b0k8.png)



Step 14: Additional Configurations


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/uxh4nxwfe2smzhvbyx5o.png)



Step 15: Leave Encryption and Maintenance as Default
- Leave encryption and maintenance settings as default.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w16x67bxroefn5hg2mef.png)



Step 16: Create Database.
- Click on the "Create Database" button to start the database creation process.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/p8znlxfrefuosbhfbkw1.png)


Step 17: View Credentials
- Once your database is created successfully, click on "View Credentials."

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dgaxl9zkpymz7ovnsmif.png)



Step 18: Copy the Endpoint and Port Number
- Copy the endpoint and port number from the database table. You now have a fully functional PostgreSQL database on Amazon AWS!

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tbrzeyzhzv728miuobm4.png)



Conclusion:
Congratulations! You've successfully set up a PostgreSQL database on Amazon AWS. If you have any further questions or need assistance, feel free to reach out. Happy coding!