Hi! Has anyone ever replicated a Xano database to an external PostgreSQL instance (hosted outside of Xano)?
I’m trying to figure out how to do that. I did a quick search online but couldn’t find much information.
My initial thought is that it might be possible using the “Direct Connect” option, which lets you access the database directly — meaning we could potentially use native PostgreSQL features to set up some kind of replication. But I’m not an expert in this area, and I wouldn’t be surprised if Xano has some hidden limitations or quirks that get in the way.
The goal here would be to have a replicated database where I can run heavier read operations (e.g. Metabase dashboards, data exports, etc.) without impacting the production environment.
Any thoughts or suggestions?