Postgresql

Ubuntu

How to Install PostgreSQL on Ubuntu 20.04

How to Install PostgreSQL on Ubuntu 20.04

We hope this post helped you to find out How to Install PostgreSQL on Ubuntu 20.04

Reading full article here https://www.mstvlife.com/how-to-install-postgresql-on-ubuntu-20-04/

PostgreSQL or Postgres is an open-source general-purpose object-relational database administration system with many superior options that permits you to construct fault-tolerant environments or advanced purposes.

On this information, we are going to clarify learn how to set up the PostgreSQL database server on Ubuntu 20.04, and discover the fundamentals of PostgreSQL database administration.

Contents [hide]

• 1 Conditions #
• 2 Set up PostgreSQL on Ubuntu #
• 3 PostgreSQL Roles and Authentication Strategies #
• 4 Creating PostgreSQL Role and Database #
• 5 Enable Remote Access to PostgreSQL server #
• 6 Conclusion #

Conditions #

To have the ability to set up packages, it is advisable be logged in as root or person with sudo privileges.

Set up PostgreSQL on Ubuntu #

On the time of writing this text, the newest model of PostgreSQL accessible from the official Ubuntu repositories is PostgreSQL model 10.4.

Run the next instructions to put in PostgreSQL server on Ubuntu:

sudo apt update
sudo apt install postgresql postgresql-contrib

We’re additionally putting in the PostgreSQL contrib package deal that gives a number of extra options for the PostgreSQL database system.

As soon as the set up is accomplished, the PostgreSQL service will begin routinely. Use the psql device to confirm the set up by connecting to the PostgreSQL database server and printing its model:

sudo -u postgres psql -c "SELECT version();"
PostgreSQL 12.2 (Ubuntu 12.2-4) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-8ubuntu1) 9.3.0, 64-bit

That’s it. PostgreSQL has been put in, and you can begin utilizing it.

PostgreSQL Roles and Authentication Strategies #

Database entry permissions inside PostgreSQL are dealt with with the idea of roles. A job can characterize a database person or a bunch of database customers.

Reading full article here https://www.mstvlife.com/how-to-install-postgresql-on-ubuntu-20-04/

PostgreSQL helps a number of authentication methods. Probably the most commonly-used strategies are:

• Belief — A job can join with no password, so long as the situations outlined within the pg_hba.conf are met.
• Password — A job can join by offering a password. The passwords might be saved as scram-sha-256, md5, and password (clear-text).
• Ident — Solely supported on TCP/IP connections. It really works by acquiring the shopper’s working system person identify, with an non-obligatory person identify mapping.
• Peer — Identical as Ident, however it’s supported on native connections solely.

PostgreSQL shopper authentication is outlined within the configuration file named pg_hba.conf. By default, PostgreSQL is utilizing the peer authentication technique for native connections.

We hope the How to Install PostgreSQL on Ubuntu 20.04 help you. If you have any query regarding How to Install PostgreSQL on Ubuntu 20.04 drop a comment below and we will get back to you at the earliest.

We hope this post helped you to find out How to Install PostgreSQL on Ubuntu 20.04 . You may also want to see — How to Install Apache on Ubuntu 20.04

Reading full article here https://www.mstvlife.com/how-to-install-postgresql-on-ubuntu-20-04/