How to Identify Unused Index in PostgreSQL
See the below Query to find Unused index in PostgreSQL
PostgreSQL 12 Installation in RHEL8 Server
[root@testdbsvr01~]# dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
[root@testdbsvr01~]# dnf -qy module disable postgresql
[root@testdbsvr01~]# dnf install -y postgresql12-server
[root@testdbsvr01~]# dnf install -y postgresql12-contrib
[root@testdbsvr01~]# /usr/pgsql-12/bin/postgresql-12-setup initdb
Initializing database ... OK
How to Identify PostgreSQL Installed Version
- Read more about How to Identify PostgreSQL Installed Version
- Log in to post comments
[root@dbserver1 ~]# su postgres
bash-4.4$ psql -A -t -c "select version()"
PostgreSQL 12.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit
How to install PgAdmin4 in Centos 7 Server
This step should have been completed upon the installation of PostgreSQL, but if you haven’t, you can complete it with:
Install Repository
yum -y install https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Now you are ready to install pgAdmin with:
Install Dependencies