I have a running XTDB using PG as the storage engine. Now I’d like to setup replication for my PG. Then when I’m trying to connect with the replica, it throws exception around ‘create table tx_events if not exists’, because the replica is read-only. My use case is that I’d like to setup a stand-by node that connects with a replica db ( and I will periodically sync the index file between the master and the stand-by node).
Hey @blshao84 this seems like a reasonable thing to be able to configure. I’ve opened an issue to keep track, but short of an upstream change I believe you would need to fork and maintain your own JDBC module. I’ll drop you an email to discuss more options to resolve / workaround.
Thanks, that seems like a neat solution (although I’m not the best person on the team to judge!). Did you decide to opt for this overall approach instead of the native horizontal scaling we discussed? Or is this in addition?
Do you already have the ability to maintain and release on your own? We don’t have a new v1 release in the pipeline yet so scheduling might be tricky for us if you need this upstream soon.
We will do both. This is a temporary fix that will buy us more time for a proper horizontal scaling solution.
Regarding to release, TBH there’s no one in my team had Clojure experience in the past. If I had a choice I would be go with a release from your side. If there’s no plan at all, I might have to do it my own anyway (maybe for the jdbc module only)