All Stories

How 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 certificate. Let’s start.

In Apache, Aug 08, 2021

How 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. terminate, kill and drop will be used interchangeably through th...

In PostgreSQL, Aug 07, 2021

How 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, Aug 06, 2021

How 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, Aug 05, 2021

How 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, 2021

How 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 gonna show you how to import CSV file ...

In MySQL, Aug 03, 2021

How to resolve PostgreSQL FATAL: sorry, too many clients already

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, 2021

How 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, Aug 01, 2021

How to fix Terraform's 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

How to install MySQL on Rocky Linux 8

Installing MySQL on Rocky Linux it’s quite easy and quick. A lot of today’s applications are using MySQL as a web database. MySQL is an open source database and offers a lot of features.

In MySQL, Jul 30, 2021