All Stories
How to whitelist IP addresses in Nginx
We all know what firewalls are for, but sometimes they can become a pain in the arse, and we all end up opening HTTP and HTTPS port by default. Let’s say we host multiple domains via ...
In Nginx, Aug 09, 2021How to secure Apache with Let's Encrypt on Rocky Linux 8
As a part of the Certbot installation in this tutorial, you will see how to secure your Apache web server with a free Let’s Encrypt SSL/TLS certificate. Let’s start.
In Apache, Let's Encrypt, Rocky Linux, Aug 08, 2021How to terminate connections in PostgreSQL
As part of the PostgreSQL series, in today’s tutorial, we are going to focus on how to list and terminate connections.
In PostgreSQL, Aug 07, 2021How to secure Nginx with Let's Encrypt on Rocky Linux 8
Previously we saw How to install Certbot on Rocky Linux 8 depending on your web server, whether it’s Nginx or Apache. In this tutorial, I’m going to show you how to secure your Nginx ...
In Nginx, Let's Encrypt, Rocky Linux, Aug 06, 2021How to install Certbot on Rocky Linux 8
Installing Certbot on your Rocky Linux server/machine is usually meant to be used to switch an existing HTTP site to work in HTTPS. It’s a helpful tool written in python which helps y...
In Certbot, Rocky Linux, Aug 05, 2021How to terminate idle transactions in PostgreSQL
As part of the PostgreSQL series, in today’s tutorial, we are going to see on how to set idle_in_transaction_session_timeout parameter and handle idle transactions, so you won’t face ...
In PostgreSQL, Aug 04, 2021How to import CSV file into MySQL table
Importing the data through MySQL Workbench or phpMyAdmin can cause some limitation issues, so things will get complicated. In this tutorial, I’m going to show you how to import CSV fi...
In MySQL, Aug 03, 2021How to resolve PostgreSQL 'FATAL: sorry, too many clients already' error
As part of the PostgreSQL series, in today’s tutorial, we are going to see on how to deal with one of the most often seen PostgreSQL errors:org.postgresql.util.PSQLException: FATAL: s...
In PostgreSQL, Aug 02, 2021How to install PostgreSQL on Rocky Linux 8
Installing PostgreSQL on Rocky Linux follows the same procedure as MySQL. We need to enable the PostgreSQL module, install the desired version and enable the PostgreSQL service. Follo...
In PostgreSQL, Rocky Linux, Aug 01, 2021How to fix Terraform 'acquiring the state lock' error
A couple of days ago, I was deploying a Terraform ECS cluster, and during the terraform plan command, I forgot to add a module. Didn’t want to wait it out until the command finish, so...
In Terraform, Jul 31, 2021