Reduced copy of zabbix database
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.
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.