DB architecture?

Question

PostgreSQL

Here is the central base. On a Linux server. And you need to collect data from the sensor on Windows.
And a break in the line from win machines to the central rack is possible.
Does it make sense to make a local database on each server with sensors so that in the event of a break, data is not lost? And what technology can be used? There is no desire to raise a postgres server on each wheelbarrow and set up replication.

Answer 1

you need rabbitmq or something like that. Distributed data bus with buffers for reliable message delivery. Or something with redis.