Hacker News new | ask | show | jobs
by jordonias 1554 days ago
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.
2 comments
porsager 1554 days 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 ;)
link
lowwave 1553 days 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.
link
porsager 1546 days 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

link