Im setting up a replication database with postgres. and it seems there are much informations about how to setting up, but I still can't find how to operate it in application.
What I want is to 'select' only from the repl db, and 'insert/update/delete' from the source db. In this case, should I have to connect to repl db everytime I select, and connect to source db in other cases, "in application level"? Or is there any way to make these all automated?
I mean, it seems there must be way to make it automated, because if there are really many repl db(more than 2), it must be working so.
please help me, thank you all.
What I want is to 'select' only from the repl db, and 'insert/update/delete' from the source db. In this case, should I have to connect to repl db everytime I select, and connect to source db in other cases, "in application level"? Or is there any way to make these all automated?
I'm not sure why you want to do that, but most don't do that and I'm not aware of any available solutions that do it. If that is what you want to do, yes, you would need to handle that in your application code.