News for hackers. Stuff that matters.

A comment on Show HN: Postgres.js – Fastest Full-Featured PostgreSQL Client for Node and Deno.

Re:Show HN: Postgres.js – Fastest Full-Featured PostgreSQL C... by jordonias on Thursday March 24, 2022 @11:36PM (#30798391)
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.

[ Parent | on HN ]
Re:Show HN: Postgres.js – Fastest Full-Featured PostgreSQL C... by porsager on Friday March 25, 2022 @05:12AM (#30799998)
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 ;)
[ Parent | on HN ]
Re:Show HN: Postgres.js – Fastest Full-Featured PostgreSQL C... by lowwave on Friday March 25, 2022 @11:47AM (#30803558)
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.
[ Parent | on HN ]
Re:Show HN: Postgres.js – Fastest Full-Featured PostgreSQL C... by porsager on Saturday April 02, 2022 @05:07AM (#30886868)
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

[ Parent | on HN ]