Postgresql

PostgreSQL installation, configuration, user management, and administration.

Oct 30, 2026 • 9 min read

How to Install PostgreSQL on Debian 13

Install PostgreSQL 17 on Debian 13, create an application role and database, and configure password authentication and remote access.

Oct 25, 2026 • 12 min read

How to Install Odoo 20 on Ubuntu 24.04

Install Odoo 20 on Ubuntu 24.04 from source in a Python virtual environment, run it as a systemd service, and serve it over HTTPS through Nginx.

Database archive with bidirectional arrows illustrating PostgreSQL backup and restore

Jun 21, 2026 • 13 min read

PostgreSQL Backup and Restore with pg_dump and pg_restore

Use pg_dump, pg_restore, and pg_dumpall to back up and restore PostgreSQL databases, including custom formats, parallel jobs, remote hosts, and test restores.

Apr 25, 2026 • 4 min read

How to Install PostgreSQL on Ubuntu 26.04

Install PostgreSQL 18 on Ubuntu 26.04, create roles and databases, and configure remote access.

Apr 18, 2026 • 3 min read

How to Check the PostgreSQL Version

Check the PostgreSQL server version from the command line with postgres --version, or from within a database session using SELECT version() or SHOW server_version. You can also check the psql client version separately.

Apr 16, 2026 • 9 min read

PostgreSQL User Management: Create Users and Grant Privileges

Step-by-step instructions for creating PostgreSQL users (roles), setting passwords, and granting or revoking privileges on databases, schemas, and tables.

PostgreSQL user management: create roles and grant privileges

Apr 16, 2026 • 4 min read

How to List PostgreSQL Databases and Tables using psql

List PostgreSQL databases and tables from the psql shell using meta-commands and SQL queries.

PostgreSQL Show / List Databases and Tables

Oct 26, 2021 • 9 min read

How to Install Odoo 15 on Ubuntu 20.04

This article explains how to install and deploy Odoo 15 inside a Python virtual environment on Ubuntu 20.04. Odoo is a popular open-source suite of business apps that help companies to manage and run their business.

Nov 2, 2020 • 9 min read

Install Odoo 14 on CentOS 8

This article explains how to install and deploy Odoo 14 inside a Python virtual environment on CentOS 8.

Install Odoo 11 in virtual environment on CentOS 8

Oct 16, 2020 • 9 min read

How to Install Odoo 14 on Ubuntu 20.04

This article explains how to install and deploy Odoo 14 inside a Python virtual environment on Ubuntu 20.04. Odoo is a popular open-source suite of business apps that help companies to manage and run their business.

May 20, 2020 • 5 min read

How to Install PostgreSQL on Ubuntu 20.04

In this guide, we will explain how to install the PostgreSQL database server on Ubuntu 20.04, and explore the basics of PostgreSQL database administration.

Dec 11, 2019 • 9 min read

Install Odoo 13 on CentOS 8

Odoo is the most popular all-in-one business software in the world. In this tutorial, we’ll show you how to install Odoo 13 from source inside a Python virtual environment on a CentOS 8 machine.

Nov 18, 2019 • 5 min read

How to Install PostgreSQL on CentOS 8

In this guide, we will discuss how to install the PostgreSQL database server on CentOS 8. We will also explore the basics of PostgreSQL database administration.

Oct 25, 2019 • 5 min read

How to Install PostgreSQL on Debian 10

This tutorial walks you through the steps of installing the PostgreSQL database server on Debian 10. PostgreSQL, often known simply as Postgres, is an open-source general-purpose object-relational database management system.

Oct 19, 2019 • 9 min read

How to Install Odoo 13 on Ubuntu 18.04

In this guide, we will walk you through installing and deploying Odoo 13 inside a Python virtual environment on Ubuntu 18.04. We'll download Odoo from their Github repository and using Nginx as a reverse proxy.

Feb 13, 2019 • 5 min read

How to Install PostgreSQL on Debian 9

PostgreSQL, often known simply as Postgres, is an open-source general-purpose object-relational database management system. In this tutorial we will show you how to install PostgreSQL on Debian 9 and explore the fundamentals of basic database administration.

Feb 13, 2019 • 6 min read

How to Install PostgreSQL on CentOS 7

PostgreSQL or Postgres is an open-source general-purpose object-relational database management system. In this tutorial we will show you two different methods on how to install PostgreSQL on your CentOS 7 machine.

Feb 13, 2019 • 5 min read

How to Install PostgreSQL on Ubuntu 18.04

PostgreSQL or Postgres is an open-source general-purpose object-relational database management system. In this tutorial we will show you how to install PostgreSQL on Ubuntu 18.04 and explore the fundamentals of basic database administration.

Jan 20, 2019 • 6 min read

How to Install Odoo 11 on Ubuntu 16.04

Odoo is one of the most popular business softwares in the world. This guide covers the steps necessary for installing and configuring Odoo using Git source and Python virtual environment on Ubuntu 16.04

Oct 30, 2018 • 5 min read

Install Odoo 12 on CentOS 7

Odoo is the most popular all-in-one business software in the world. In this tutorial, we’ll show you how to install Odoo 12 from source inside a Python virtual environment on a CentOS 7 machine.

Install Odoo 11 in virtual environment on CentOS 7