Michael Monte

icon indicating an email [email protected]

icon location A PostgreSQL DBA interested in building scalable, optimized, and secure PostgreSQL infrastructures. I dabble in other things here as well.

Results 3 comments of Michael Monte

pgbench fails with error "cannot execute UPDATE in a read-only transaction"

@swchangdev @GPF199541 @sidartha Do you all have the `query_parser_read_write_splitting = true` config entry in the pgcat.toml? It will not even try to infer the query without that.

pgbench fails with error "cannot execute UPDATE in a read-only transaction"

An example of my very simple config, and it is working as expected. Also I am not using any postgres specific SQL. Simple updates and inserts. ``` # This is...

select nextval() goes to read replica

> After did some quick debugging, it seems the query_router.infer() seems never been called in client.rs. This won't help for the `nextval()`, but if queries aren't getting "infered", make sure...