Install PostgreSQL12 On SUSE Linux in AWS

Share via:

Dear Readers,

In this article, we will see the following Install PostgreSQL12 On SUSE Linux.

Steps to Follow :
  1. Logging to AWS Account
  2. Launch PostgreSQL EC2 Instance
  3. Connect to Linux EC2 Instance by Using Putty
  4. Add PostgreSQL Repository
  5. Install PostgreSQL 12
  6. Enable the PostgreSQL
  7. Start the PostgreSQL
  8. Switch to Postgres User
  9. Connect to the  Default Database “postgres”

 

1. Logging to AWS Account

First, we need to AWS Console page by using below link.

https://aws.amazon.com/console/

Click on sign in to Console button.

Logging to aws account

Login using username & password and click on sign in.

Enter to AWS Management Console

We can see the AWS Management Console Dashboard.

Go to Services, under the compute module click EC2 service to open.

2. Launch PostgreSQL EC2 Instance

Go to Services, under the compute module click EC2 service to open.

We can launch Linux EC2 Instance by using below link.

Launch Linux EC2 Instance

We can see the Linux server has been launched successfully.

3. Connect to Linux EC2 Instance Using Putty

We can connect putty by using below link.

Connect to EC2 Instance Using Putty

4. Switch to root user

5. Install Server Updates

6. Add PostgreSQL Repository 

Go to PostgreSQL official website by using below link.

https://zypp.postgresql.org/

Click on Download.

Select the Linux Operating System and click on SUSE Linux Distribution.

Click on Instructions.

Go to PostgreSQL 12 and copy the command for adding the PostgreSQL 12 repository.

Go to the Server Terminal and run the above command

7. Install PostgreSQL 12  

Go to PostgreSQL 12 and copy the installation command.

Go back to terminal and run the installation command

Check the Version of PostgreSQL 

8. Enable PostgreSQL

9. Start the PostgreSQL 

Check the Status of PostgreSQL 

Note :
When you install the postgres one user and database will be created postgres.

10. Switch to Postgres User 

11. Connect to the default Database “postgres” 

Check the Version of PostgreSQL  

Check the List of the Databases  

Check the List of Users

Check the Current User 

Exit from the Cluster

 

Thank you for giving your valuable time to read the above information.
Follow us on 
Website  www.ktexperts.com
Facebook Page KTexperts
Linkedin Page : KT EXPERTS

Follow Me
Ramesh’s Linkedin : Ramesh Atchala

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 4.00 out of 5)
Loading...

Add Comment