Differences

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

--- linux:monitoring:zabbix:database:postgresql:partitioning [2020/03/31 12:31]
jlucas
+++ linux:monitoring:zabbix:database:postgresql:partitioning [2020/04/02 08:20] (current)
jlucas [Dump individual Zabbix database tables for testing]
@@ Line 41: / Line 41: @@
 ====Dump the entire Zabbix DB====
-Use this to dump the entire Zabbix database + schema structure.
+dump the entire Zabbix database
-  sudo su _postgresql
   pg_dump -U zabbix zabbix | gzip -1 > ./zabdb.zabbix.Pg.gz
+  pg_dump -U postgres postgres | psql -U zabbix zabbix
+====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
+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: