All Stories

How to list Indexes in PostgreSQL

This week is all about listing things in PostgreSQL, and I’m gonna start with indexes. Indexes are basically tables that points to data in other tables, therefore speeding up the quer...

In PostgreSQL, Feb 07, 2022

How to install Apache on AWS EC2 Amazon Linux 2 instance

Once you have provisioned an AWS ec2 instance installing Apache on amazon linux 2 is a straightforward and easy process. Here I’m going to show you how to install Apache web server on...

In AWS, Apache, Feb 06, 2022

How to restore an individual table in PostgreSQL

Backup and restore operations are convinient if we are working with small and medium-sized data. But, what happens when we need to restore a single table from a large database?! Most ...

In PostgreSQL, Feb 05, 2022

How to configure basic caching in Nginx

As the cache need grows for a big data applications, technology market offers a lot of different caching solutions. Today I want to show you how to set up basic caching and cache your...

In Nginx, Feb 04, 2022

How to fix 'type: geography does not exist' error in PostgreSQL

Restoring PostgreSQL databases could be sometimes tricky and most likely so include a few errors. In today’s issue resolving series, we are going to deal with the following error: typ...

In PostgreSQL, Feb 03, 2022

MySQL Check for Corrupted Tables

Exporting and importing MySQL databases and tables sometimes can cause corruption. But there are a lot of different reasons why the MySQL table can get corrupted. Here in this tutoria...

In MYSQL, Feb 02, 2022

How to fix Telnet SMTP 'must issue STARTTLS command first' error

If you have already been testing the Telnet’s gmail smtp, you must have seen the following error:530 5.7.0 Must issue a STARTTLS command first. - gsmtpThis means that you have didn’t ...

In SMTP, Feb 01, 2022

How to remove frozen emails from the Exim mail queue

Messages or emails that are sent to a non-existent email account can sit in the mail queue and maybe cause issues or stuck the relevant ones. After some period of time, usually 7 or 8...

In Exim, Jan 31, 2022

base64 encode and decode from the CLI

base64 encoding and decoding has many use cases, but it’s important to understand that it’s different from encryption and decryption. While base64 encoding focuses on data usability s...

In base64, Jan 30, 2022

How to rotate screen position in Ubuntu through CLI

Nowadays as technology develops more and more, laptops are becoming more sophisticated. Most of today’s laptops offer a finger-sensitive screens so you can manage to flip over the mon...

In Ubuntu, Jan 29, 2022