node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
Hi, Our software seems to use sometimes connection that didn't respond. We use PGBouncer between the database and our software. Is there a clean way to test the connection before...
We have a service that uses cursors to populate an elasticsearch cluster. This morning, a large operation caused our read-replica to lag behind long enough for postgres to kill off...
Using the "pg" package 8.5.1 To replicate the issue, save some large data as a blob into the database. In my case 340 MB was enough to trigger the bug....
I have been trying to get to the bottom of this issue https://github.com/brianc/node-postgres/issues/1952 and along the way I have discovered that the latter issue is not present when using pg-native....
When pg.Pool is accidentally passed "undefined" as its connectionString, it (at least on my Windows machine) results in the error message "Server does not support SSL connections", which makes debugging...
I have been observing a strange behaviour where PostgreSQL backends created by node-postgres are hanging in ClientRead state. ``` cinema_data_task_executor=> SHOW statement_timeout; statement_timeout ------------------- 10s (1 row) cinema_data_task_executor=> SELECT cinema_data_task_executor->...
This fixes #2686 This is a simple fix that gets the job done. I've done the same thing that is done with `_arrayMode`: update the value on the `client.native` and...
Hi 👋🏻 Thanks for this awesomely maintained & documented library 🙏🏻 ## Problem We're using AWS RDS for PostgreSQL with Multi-AZ and found the failover process taking a little too...
Now that `rejectUnauthorized` is being defaulted to true, there is no way to modify that from the connection string. Some libraries ([example](https://github.com/gajus/slonik/blob/ee43f02378dc8272d7d2702ccd105f7a3abd04f2/src/factories/createPoolConfiguration.js#L31) are setting opposite defaults to try and ease...
The PR at https://github.com/brianc/node-postgres/pull/1926 solves part of my problem. In RDS I'm using password rotation with a secondary postgres user, which means that every rotation the username toggles between `username`...
