Reduced copy of zabbix database

by avelo   Last Updated March 13, 2018 08:06 AM

I've a relatively big postgresql database that tooks a lot of space in a server. The database stores a zabbix system used to monitor data that I've to safely keep, so history tables are quite big.

My guess would be to replicate this big DB in another server with a lot of space (but not so stable network connection), and keep a somehow light version of recent data in main server.

I took a look to options as partitioning, WAL..., but I think that they don't fit the requirements, so I'm starting to consider that I've to redesign the full system.

Any ideas? all help appreciated.



Related Questions


How to shrink space on table with function based index

Updated January 27, 2017 14:02 PM


Postgres command failed: No space left on device

Updated July 05, 2016 08:02 AM

How to reclaim disk space on PostgreSQL?

Updated May 17, 2017 09:06 AM