RHEVMPostgreSQL数据库相关-创新互联

[root@rhevm dbscripts]# ./backup.sh -l /usr/share/ovirt-engine/db-backups/ -u engine
Backup of database engine to/usr/share/ovirt-engine/db-backups//engine_Mon_Dec_31_13:58:52_CST_2012.sql started......
...
Backup of database engine to/usr/share/ovirt-engine/db-backups//engine_Mon_Dec_31_13:58:01_CST_2012.sql completed.[root@rhevm dbscripts]# ll ../db-backups/
total2300-rw-r--r-- 1 root root 2351307 Dec 31 13:58 engine_Mon_Dec_31_13:58:01_CST_2012.sql

#修改数据库IP地址监听

[root@rhevm ovirt-engine]# netstat -anlpt|grep post
tcp0 0 0.0.0.0:5432  0.0.0.0:*                   LISTEN 18408/postmaster    
tcp0 0 127.0.0.1:5432   127.0.0.1:47357             ESTABLISHED 18499/postgres      
tcp0 0 127.0.0.1:5432   127.0.0.1:47358             ESTABLISHED 18604/postgres      
tcp0 0 :::5432                     :::*     
[root@rhevm ovirt-engine]# cat /var/lib/pgsql/data/postgresql.conf  |grep listen
#listen_addresses= 'localhost'         # what IP address(es) to listen on;
listen_addresses= '*'          # what IP address(es) to listen on;
[root@rhevm ovirt-engine]# cat /var/lib/pgsql/data/pg_hba.conf  |grep host
host    all         all127.0.0.1/32          md5
host    all         all         ::1/128               md5
host    all         all10.12.0.0/16          md5
[root@rhevm ovirt-engine]# /etc/init.d/postgresql restart