Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
linux:monitoring:zabbix:database:postgresql:partitioning [2020/04/01 18:15] – [Dump individual Zabbix database tables for testing] jlucaslinux:monitoring:zabbix:database:postgresql:partitioning [2020/04/02 15:20] (current) – [Dump individual Zabbix database tables for testing] jlucas
Line 51: Line 51:
 ====Dump individual Zabbix database tables for testing==== ====Dump individual Zabbix database tables for testing====
  
 +The following use of pg_dump and pg_restore performs a data-only backup using the custom-form output option and using INSERTs instead of COPY statements:
   pg_dump -U zabbix -a --inserts -t history_str -Fc zabbix | gzip -1 > /var/postgresql/zabdb.zabbix.history_str.Pg.gz      pg_dump -U zabbix -a --inserts -t history_str -Fc zabbix | gzip -1 > /var/postgresql/zabdb.zabbix.history_str.Pg.gz   
  
 +Once the backup is done, drop all data from the table:
 +  psql -U zabbix -c 'truncate history_str;' zabbix
 +
 +Now restore the data to the table:
 +  gunzip -c zabdb.zabbix.history_str.Pg.gz | pg_restore -U zabbix -d zabbix

Trace: