zabbix 6.2 postgresql 14 timescaledb 2.7.2
I am not a postgresql db so trying to do my best here.
there are history table issues in the database it seems due to timescaledb. it's possible I didn't update some sql script into the database with some timescale db update iin the past. now we have 300 devices connected and the database is growing way too fast as I am guessing compression isn't working etc.
I don't super care about the data in the database and could just setup a new one and connect the server to it (which I tried) but the PSK data also seems like it is in the database and throws tons of errors.
my thoughts at the moment are: drop timescaledb for now and just run on postgresql which seems much simpler. but how to get just the needed data out into a new database and dump everything else
any help would be greatly apprecated.
I am not a postgresql db so trying to do my best here.
there are history table issues in the database it seems due to timescaledb. it's possible I didn't update some sql script into the database with some timescale db update iin the past. now we have 300 devices connected and the database is growing way too fast as I am guessing compression isn't working etc.
I don't super care about the data in the database and could just setup a new one and connect the server to it (which I tried) but the PSK data also seems like it is in the database and throws tons of errors.
my thoughts at the moment are: drop timescaledb for now and just run on postgresql which seems much simpler. but how to get just the needed data out into a new database and dump everything else
any help would be greatly apprecated.