Request for beta testers

[levkk]

Hey everyone!

It's been a couple weeks few months of development and I am thinking we are ready for some early end user testing. It would be good to try this pooler in low traffic / low risk environments like local development, staging and/or pre-prod, and low traffic production. This will be of great help to validate that this works in the real world and to quickly find out what features are missing.

If you'd like to volunteer, please get in touch on this thread, email me (see LICENSE for contact info) or just go ahead and try it and let me know how it went.

Thanks!

• Lev

P.S. This pooler is now licensed under MIT, so you can use it in any setting, e.g. at your company, without worrying about licensing issues.

[sgaunet]

Hello,

I'm interested (as said on medium) and give it a try today. I've got this warning: Server returned with session state altered, discarding state
I don't change anyhting to our application, and I've got this message either with default_role=any or default_role=primary

pgcat is setup in front of aws rds, I don't know if this matters. I'm using pool_mode=session and tried the transaction mode also.

In our application, it seems that the sql request have been transfered to the replica:
[ERROR] Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE sessions SET enddate = ?, services = ? WHERE sid = ? AND login = ?' with ...: SQLSTATE[25006]: Read only sql transaction: 7 ERROR: cannot execute UPDATE in a read-only transaction

Is that a bug ? I've used the last docker image found: ghcr.io/levkk/pgcat:5961d1daee8c66cd4f9a6c70aaa0caaefe9d28ef

[AWH-ai]

Can I use PGCAT for load balancing of PGSQL clusters!