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 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
Containerizing a Ruby on Rails Application for Development with Docker Compose — step-by-step Docker tutorial on Progressive Robot

Containerizing a Ruby on Rails Application for Development with Docker Compose

If you are actively developing an application, using Docker can simplify your workflow and the process of deploying your application to production. This tutorial will show you how to set up a development environment for a Ruby on Rails application using Docker. You will create multiple containers – for the application itself, the PostgreSQL database, Redis, and a Sidekiq service – with Docker Compose.

Read more
How To Choose a Redundancy Plan To Ensure High Availability — step-by-step Databases tutorial on Progressive Robot

How To Choose a Redundancy Plan To Ensure High Availability

Redundancy is a way of reducing the impact of system failures by configuring multiple avenues to achieve the objective. If a disk, a computer, or an entire portion of the network becomes unavailable for some reason, various forms of redundancy can help mitigate the impact on your currently running systems. This will allow you to address the issue without experiencing downtime.

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

How To Install and Use PostgreSQL on Ubuntu 22.04

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This guide demonstrates how to install Postgres on an Ubuntu 22.04 server. It also provides instructions for general database administration.

Read more
CHAT