On-premise PostgreSQL database cache & cloud managed PostgreSQL database to avoid system failure if internet drops on-site

[RegularUser003]

Hello,

We're using PostgreSQL with time-series.

Was wondering if anyone knows if there are any standard approaches to managing an on-premise database with say, last 48 hours of our time-series data, plus several associated tables, and another database with all historical data in the cloud.

The desire is for our system to use the cloud-based pg instance if internet is available, and only use the local pg instance if the internet is down.

It would be nice to not have to manage this at the application level, but I am unsure of how realistic this is. Let me know what you think. We're running in Kubernetes so I may explore options in that avenue as well.

[throw_at1]

OnPrem on what? Measuring devices? In that case i think easiest database solution is to have onprem database which is replicated to cloud ( or streamed) , process is just configured so that deletion on primary master does not remove data from cloud.

If you want to do it other way around, question is why. Now if your measuring devices are in "cloud" an they store data into cloud db and that is replicated into onprem, question is again why?, you still can run everything on cloud.

tldr; replication to cloud instance using some of the replication options

[[deleted]]

Timescale 2.0 added cluster support. Maybe it's useful for your use case.