Support reads from replicas

[jesperpedersen]

This should be done as a separate pipeline

[dtseiler]

Do you mean routing SELECTs to replicas here, while keeping DML on a primary?

What if I just want to set up an entry for a replica DB? I'm not interested (yet) in fancy statement routing. I just want to have an entry that points to my primary and a separate entry that points to my replica. I'll have my app determine which connection to use. Can pgagroal support that today?

[digoal]

how to filter udf, when select udf, which udf has some dml or nested udf has some dml.

[jesperpedersen]

@dtseiler pgagroal will allow connections to replicas at the moment. However, it does not check any of the messages sent, so you may get errors if you are doing INSERT, UPDATE, DELETE, UDF, ...

@digoal Precisely, this is a big concern about this feature.

Since it is an active issue it will be on the roadmap at some point, but I can't say when it will hit a release.

[dtseiler]

Right so you were originally talking about statement routing. That wasn't obvious to me from the title of the issue. Thanks.