개요PostgreSQL dump & restore 관련 명령어 dump & restore# sudo dnf install -y https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-8-x86_64/postgresql14-14.13-1PGDG.rhel8.x86_64.rpm# psql -h -p 5432 -U user -d Password for user user: psql (14.13, server 13.15)Type "help" for help.database=> \l List of databases Name | Owner | Encoding | Coll..

개요Rocky Linux 8에 PostgreSQL client 설치 방법  설치 및 삭제 방법## PostreSQL Repository 추가# sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm## 설치하려는 버전의 PostreSQL Module 활성화# sudo dnf module enable postgresql:12## 설치# sudo dnf install -y postgresql## 삭제# sudo dnf remove postgresql# sudo dnf module reset postgresql## 다른 버전 Module 활성화# s..

- client access psql -h -U -d -W - database list SELECT datname FROM pg_database WHERE datistemplate = false; - process list select * from pg_stat_activity;