How to Install PostgreSQL on Ubuntu 20.04

In this article, we will have explained the necessary steps to install and configure PostgreSQL on Ubuntu 20.04 LTS. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.

PostgreSQL is an open source, powerful, advanced, high performance and stable relational-document database system. It uses and enhances the SQL language coupled with a large number of features for secure data storage and management.

Install PostgreSQL on Ubuntu

Step 1. First, before you start installing any package on your Ubuntu server, we always recommend making sure that all system packages are updated.

Step 2. Install PostgreSQL on Ubuntu system.

Run the following commands to install PostgreSQL server on Ubuntu:

Once the installation is completed, the PostgreSQL service will start automatically. To check the Postgres version and confirm installation run following psql command:

Step 3. PostgreSQL Roles and Databases.

PostgreSQL supports multiple authentication methods. The most commonly used are:

• Trust – With this method, the role can connect without a password, as long as the criteria defined in the pg_hba.conf are met.
• Password – A role can connect by providing a password. The passwords can be stored as scram-sha-256 md5 and password (clear-text)
• Ident – This method is only supported on TCP/IP connections. Works by obtaining the client’s operating system user name, with an optional user name mapping.
• Peer – Same as Ident but it is only supported on local connections.

You can log in to PostgreSQL using below command:

To exit from here type following in the terminal:

Step 4. Create PostgreSQL Database and Role.

• Create a new PostgreSQL RoleThe following command will create a new role named meilana:
  1	<spanclass="line">sudosu-postgres-c"createuser meilana"</span>

• Create a new PostgreSQL DatabaseCreate a new database named meilana using the createdb command:
  1	<spanclass="line">sudosu-postgres-c"createdb meilanadb"</span>

• Grant privilegesTo grant permissions to the ramona user on the database we created in the previous step, connect to the PostgreSQL shell:
  1	<spanclass="line">sudo-upostgrespsql</span>

  and run the following query:

  1

  <spanclass="k">grant</span><spanclass="k">all</span><spanclass="k">privileges</span><spanclass="k">on</span><spanclass="k">database</span><codeclass="language-console-bash"data-lang="console-bash"><spanclass="line">meilanadb</span></code><spanclass="k">to</span><spanclass="n">meilana</span><spanclass="p">;</span>

Step 5. Enable remote access to PostgreSQL server.

Use the following steps to enable remote access to the PostgreSQL server:

Update listen_addresses like given below:

Now restart the PostgreSQL service with systemctl command:

Verify the changes with the ss utility:

Finally update pg_hba.conf file to configure server remote connections using below examples:

That’s all you need to do to install PostgreSQL on Ubuntu 20.04 LTS Focal Fossa. I hope you find this quick tip helpful. Don’t forget to share your valuable queries/suggestions in the below comment box & also drop your worthwhile feedback.