升级CentOS5.4,修改Postgresql二三事
##5.4 出了,升级吧 ;-)yum upgrade
##等待
##
lsb_release-a
LSB Version::core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID:CentOS
Description:CentOS release 5.4 (Final)
Release:5.4
Codename:Final
yes!
##基于文件系统的Postgresql恢复,遇到postmarster读取postgresql.conf permission dennied
## 修改SElinux配置文件,关闭selinux,
修改和关闭selinux的两种办法：
1 在lilo 或者grub的启动参数中增加：selinux=0
2 修改/etc/selinux/config文件（redhat 类似系统下)
## 后遭遇版本不一致不能恢复...
uname -a
##杂念,备忘
##
--- Check the dbsize on postgresql
SELECT
pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname))
AS size FROM pg_database;
页:
[1]