Postgresql常见问题
小于 1 分钟
提示
Postgresql常见问题
1. 删除数据库后,解锁占用
drop DATABASE {{DB_NAME}};
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname='{{DB_NAME}}' AND pid<>pg_backend_pid();
2. yum/dnf安装与默认路径
// 安装
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql14-server
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14
// 卸载
sudo systemctl stop postgresql-14
rpm -qa | grep postgresql
sudo yum remove postgresql14-libs-14.0-1PGDG.rhel8.x86_64 postgresql14-server-14.0-1PGDG.rhel8.x86_64 postgresql14-14.0-1PGDG.rhel8.x86_64
sudo rm -rf /var/lib/pgsql
sudo rm -rf /usr/pgsql-14