Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Running TS on replicated streaming postgres read only server #1250

Open
bkd opened this issue Aug 5, 2023 · 0 comments
Open

Running TS on replicated streaming postgres read only server #1250

bkd opened this issue Aug 5, 2023 · 0 comments

Comments

@bkd
Copy link

bkd commented Aug 5, 2023

I have set up a relocation/master to have the indexing done on a replicated postgres node.

Setup is as follows:

Main server + code base + postgres main
Replication server+ code base + postgres replica

I will execute the ts:merge on the replication server NOT the main server

Naturally doing ts:merge is hitting the read-only database and trying to update the delta. It would be great to allow any rake that modifies the data to do this on the main server instead, then allow the indexing to be done without affecting performance - any suggestions to make this work?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant