August 25, 2024

postgresql

PostgreSQL: Basic commands

We will use a CentOS server to install PostgreSQL. The below command installs the PostgreSQL server. [root@SHIJU-TEST-PGSQL-01 ~]# dnf install postgresql15-server -y [root@SHIJU-TEST-PGSQL-01 ~]# postgresql-setup initdb [root@SHIJU-TEST-PGSQL-01 ~]# systemctl start postgresql [root@SHIJU-TEST-PGSQL-01 ~]# systemctl status…