The following article describes how to configure PostgreSQL 12+ replication between the primary master and secondary slave server; both hosted on CentOS 8. Intro I am going to keep this...

The following are an easy to follow steps to change the data directory in PostgreSQL 12. FIND THE LOCATION OF POSTGRES CONFIG FILE In your DB console execute the following...

If you get an uncaught error: Call to undefined function pg_connect() when using PHP to PostgreSQL connection, it's pretty easy to fix it on Centos 8. Just install the PostgreSQL...

The following article shows how to fix the Webmin PostgreSQL 12 error that says: The PostgreSQL host configuration file /var/lib/pgsql/data/pg_hba.conf was not found on your system, indicating that the database...

A simple set of instruction on how to install PostgreSQL 12 on Centos 8.x INSTALLATION Install latest repos for EL-8: sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm Let's check if Postgres 12...

Recently I came across a situation where I needed to perform the MySQL search in such way, that it would account for typos in user search queries. For example, if...

Recently, I came across a post from 2001 which allowed downloading the entire collection of UTZOO NetNews Archive of earliest USENET posts. These were essentially the earliest available discussions posted...

Recently I came across a need to create a Linux shell script to run a PostgreSQL SQL query, export it in CSV Format and send it attached to an email....

The following post outlines the process of converting Aspell language dictionary for any language into Mysql or MariaDB database. Step 1 - Install Aspell + Language Dictionary I will illustrate...

It happens from time to time that we have duplicate queries in our database Unique index type tables that are caused by difficult to detect carriage returns. The following method...