All Stories
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
How to pg_dump to S3 directly
Just before we start with this tutorial, I just wanna say, don’t try this on production. Streaming pg_dump backup directly to S3 bucket is a bad practice to start with, unless you are...
In PostgreSQL, AWS, Jul 29, 2021
How to determine the correct number of max children processes for PHP-FPM
Most of the PHP developers are using Nginx with php-fpm as the most efficient approach. Most likely nginx will throw php errors, that the server reached the pm.max_children number. It...
In PHP, Jul 28, 2021