3 ms·

I spent some time today trying to replace pg but I ran into an issue. When using an rds proxy with iam authentication, it seems to repeatedly retry authenticati

I spent some time today trying to replace pg but I ran into an issue. When using an rds proxy with iam authentication, it seems to repeatedly retry authentication and eventually my lambda functions time out. If I switch to using regular credentials it works fine. Using the exact same options with pg+iam authentication also works fine which leads me to believe it's an issue with this project. I'll open an issue on GitHub tomorrow.

porsager 5y ago
That's interesting - haven't heard of that issue before, so do please create an issue on github or let me know if you figure it out ;)
lowwave 5y ago
Be very interesting to know if it is the rds proxy that is causing the problem. It is one things that annoys me about rds and aws services.
- porsager 5y ago
  It was indeed the RDS Proxy. It appers to be very strict about the client_encoding parameter. Postgres.js was sending 'utf-8' which PostreSQL will understand, but RDS Proxy would just hang until this was changed to UTF8 (uppercase with no dash). https://github.com/porsager/postgres/issues/288 https://github.com/porsager/postgres/issues/288