All Stories
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.
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, 2021How 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, Rocky Linux, Jul 30, 2021How to pg_dump to AWS S3 directly
Just before we start with this tutorial, I just want to say, don’t try this on production. Streaming pg_dump backup directly to S3 bucket is a bad practice to start with, unless you a...
In PostgreSQL, AWS, Jul 29, 2021