App overview screenshotSQL and Database Guides
PostgresMySQL
Try our free SQL Client
Tools
Connecting to Postgres
Connecting to drivers
Installing Postgres
Setting up Postgres
Postgres   >   
Installing Postgres   >   
Postgres on Linux

How to Install PostgreSQL on Linux

PostgreSQL is one of the most popular database systems available today. In this guide, we’ll walk you through how to install Postgres on Linux.

Installing MySQL

You can install Postgres by following the commands corresponding to your Linux distribution:

  • Ubuntu

    sudo apt update
    sudo apt install postgresql postgresql-contrib
    
  • ArchLinux

    sudo pacman -S postgresql
    sudo -iu postgres
    initdb -D /var/lib/postgres/data
    
  • CentOS/Fedora/RHEL

    sudo yum -y update
    sudo systemctl reboot
    sudo dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
    sudo dnf -qy module disable postgresql
    sudo dnf install postgresql13 postgresql13-server
    sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
    

Now, we have to set a root password for our Postgres server by running psql as the newly-created ‘postgres’ user:

$ sudo -u postgres psql
postgres=# ALTER USER postgres with password ‘myPassword’;

Connect to Your PostgreSQL Database

Now, let’s connect! Open Arctype, press ‘Add New Connection’, and enter your connection information. For now, we’ll use the postgres user with the password set during installation and the database postgres:

Arctype linux PostgreSQL connection credentials

Press Test Connection to confirm that all of your information is correct and then save!

Configure Your PostgreSQL Database

Now that you have connected, you should make a few changes to improve the security of your database. The first is to create a new database that is separate from the mysql informational database you are currently connected to. Click New Query and run the following command:

CREATE DATABASE myDB

Next, you should create a new user:

CREATE USER myUser WITH PASSWORD ‘myPassword’

And finally, you’ll need to grant this user full permissions on your database:

GRANT ALL PRIVILEGES ON myDB TO myUser

Go back to the settings menu in your SQL client and switch to this new user and database. You’re all ready to start writing queries!

Want to ask for help on databases or SQL? Join our Discord community.