DPM
Home
Documentation
Download
Forum
More
This topic discusses PostgreSQL exploitation-scripts (backup,dump,stat,reorg, etc)
An example of "dpm.conf" for an instance listenning at a VIP:
[INST1]
gv_dbms_home="/usr/pgsql-11"
gv_dbms_version="11"
gv_config_file="/inst1/pg_data/postgresql.conf"
gv_login="postgres"
gv_passwd="nq6N3UrfZwWrvXQepOyJ3K4M/zAeJTIpq7dizEmknpQ="
gv_virtual_host="vip-inst01"
gv_sql_client='psql -h $gv_virtual_host -p $gv_port -U $gv_login -d postgres'
gv_dump_cmd='pg_dump -h $gv_virtual_host -p $gv_port -U $gv_login'
gv_import_cmd='pg_restore -h $gv_virtual_host -p $gv_port -U $gv_login'
alert_level="FS:/inst1:15%:10%"
An example of "dpm.conf" for an instance listenning at a VIP:
[INST1]
gv_dbms_home="/usr/pgsql-11"
gv_dbms_version="11"
gv_config_file="/inst1/pg_data/postgresql.conf"
gv_login="postgres"
gv_passwd="nq6N3UrfZwWrvXQepOyJ3K4M/zAeJTIpq7dizEmknpQ="
gv_virtual_host="vip-inst01"
gv_sql_client='psql -h $gv_virtual_host -p $gv_port -U $gv_login -d postgres'
gv_dump_cmd='pg_dump -h $gv_virtual_host -p $gv_port -U $gv_login'
gv_import_cmd='pg_restore -h $gv_virtual_host -p $gv_port -U $gv_login'
alert_level="FS:/inst1:15%:10%"