Lev Kokotov

icon indicating a website link https://pgdog.dev/blog

icon company @pgdogdev icon location San Francisco, CA

Results 134 comments of Lev Kokotov

Pgcat is not working with asyncpg python client and I am getting this error in logs ERROR `pgcat::client] Unexpected code: H`

Hi, Thank you for reporting the issue. Could you run PgCat with `RUST_LOG=debug` and provide us with the output? Also curious what errors you get in Python. I think I...

Pgcat is not working with asyncpg python client and I am getting this error in logs ERROR `pgcat::client] Unexpected code: H`

I see. Looks like we just need to implement `H` (Flush) [1]. When receiving that message, we need to write out the client buffer to the server. [1]: https://www.postgresql.org/docs/current/protocol-message-formats.html

Pgcat is not working with asyncpg python client and I am getting this error in logs ERROR `pgcat::client] Unexpected code: H`

Yeah, that PR isn't quite right. I haven't had a chance to take a look at it yet, but if you have some time, a PR implementing support for async...

feat: SASL (SCRAM-SHA-256) authentication

Working on 2.0 as we speak. Will have some more news soon.

select nextval() goes to read replica

Take a look at the query router. It parses the SQL into an AST using the `sqlparser` crate. You should be able to identify the called functions and adjust the...

select nextval() goes to read replica

Something weird is definitely going on. Do you think you could submit a PR with a simple Java app that I can use to reproduce this? We can use that...

select nextval() goes to read replica

We can but this functionally doesn't exist, yet.

select nextval() goes to read replica

Not at the moment, but we can add that in if needed: https://github.com/postgresml/pgcat/blob/main/src/query_router.rs#L149

unrecognized configuration parameter "shard"

Is `psql` starting a transaction for you? `SET SHARD TO` must be sent outside explicit transactions (i.e. created with `BEGIN`)

Add support for UNIX sockets

This is certainly good to have, but we won't be using this in production because PgCat, clients, and Postgres will always be on separate servers. Still, good feature to have...