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.