PostgreSQL

How to Secure MySQL 9 on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Install PostgreSQL 17 on Ubuntu 26.04

PostgreSQL is a powerful, open-source object-relational database system known for its reliability, extensibility, and standards compliance. PostgreSQL 17 brings performance improvements, new SQL features, and enhanced logical replication. This guide installs it on Ubuntu 26.04 LTS. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Ubuntu 26.04 LTS server A user with sudo privileges Step 1 […]

Read more
How to Secure MySQL 9 on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Install pgAdmin 4 on Ubuntu 26.04

pgAdmin 4 is the most popular open-source administration and development tool for PostgreSQL. It provides a web-based interface for managing databases, writing queries, monitoring server activity, and managing schemas. This guide installs pgAdmin 4 in web mode on Ubuntu 26.04 LTS. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Ubuntu 26.04 LTS with PostgreSQL 17 […]

Read more
How To Install and Use PostgreSQL on Rocky Linux 9 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on Rocky Linux 9

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

Read more
How to Secure MySQL 8.0 on Ubuntu 24.04 — step-by-step Linux tutorial on Progressive Robot

How to Install PostgreSQL 16 on Ubuntu 24.04

PostgreSQL 16 is a powerful, standards-compliant open-source relational database. This guide installs PostgreSQL 16 on Ubuntu 24.04 LTS using the official PGDG repository for the latest release. Tested and valid on: Ubuntu 24.04 LTS Prerequisites Ubuntu 24.04 LTS server A user with sudo privileges Step 1 – Add the PostgreSQL APT Repository Import the signing […]

Read more
How to Secure MySQL 8.0 on Ubuntu 24.04 — step-by-step Linux tutorial on Progressive Robot

How to Install pgAdmin 4 on Ubuntu 24.04

pgAdmin 4 is the leading open-source web-based management tool for PostgreSQL. This guide installs the pgAdmin 4 web version on Ubuntu 24.04 LTS so you can manage databases from a browser. Tested and valid on: Ubuntu 24.04 LTS Prerequisites Ubuntu 24.04 LTS server PostgreSQL 16 installed Nginx installed A user with sudo privileges Step 1 […]

Read more
How To Install Umami Web Analytics Software on Ubuntu 20.04 — step-by-step Docker tutorial on Progressive Robot

How To Install Umami Web Analytics Software on Ubuntu 20.04

Umami is an open-source, self-hosted web analytics application written in Node.js. It focuses on being simple, well-designed, fast, and privacy-focused. It can store data about your website’s visitors in either a MySQL or PostgreSQL database. In this tutorial you will install Umami and a PostgreSQL database using Docker Compose, then install Nginx and Certbot to set up a secure HTTPS reverse proxy for Umami.

Read more
Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 20.04

Django — это мощная веб-система, помогающая создать приложение или сайт Python с нуля. Django включает упрощенный сервер разработки для локального тестирования кода, однако для серьезных производственных задач требуется более защищенный и мощный веб-сервер. В этом руководстве…

Read more
CHAT