Write Ahead Log is PostgreSQL’s transaction log. Keeps records of transactions. Before it is written to the data files, it keeps the data here and …

In today’s article, we will learn where the installation files are in PostgreSQL, how to access data, lib, bin and many similar configuration information. First, …

In today’s article, we will create and delete a database without using the Psql client. We go to the /usr/pgsql-13/bin/ directory. With the help of …

In today’s article, we will connect to postgresql and use the Postgres user and the psql command while doing this. We need to switch to …

In today’s article, we will start the PostgreSQL Cluster with the Pg_ctl command. What is the pg_ctl command? PG_CTL is the command required to start, …

The initdb command is one of the important steps for starting PostgreSQL. Cluster is created when initdb is made, and template, template1 and postgres databases …

PostgreSQL 9.2 version is common in the repos, you can install this version if you want. First, we download the postgresql 13 repo as follows. …

As with any database, PostgreSQL has some limits. The following information applies to version 13 of PostgreSQL. Maximum size for database: Unlimited Number of databases: …

With the Glances application on linux, you can view information about the processes running instantly in the system, terminate the processes you want to terminate, …

With the use of linux Top, you can view information about the processes running instantly in the system, terminate the processes you want to terminate,or …