@ndyRobinson.com

Topic

postgres

A collection of 3 issues

53300: sorry, too many clients already

Randomly started getting this error when running tests using testcontainers... Npgsql.PostgresException: '53300: sorry, too many clients already' Always the same test would fail - initially just returning a System.NullReferenceException with no indication of what was happening. After a bit of digging around found that the underlying

Enable or disable triggers

Needed to disable some triggers to allow a deployment script to run, it was taking a really long time if the triggers were enabled and the core data was not being changed so the triggers were not needed. DO $$ DECLARE t record; BEGIN FOR t IN SELECT trigger_name FROM

Determine if Postgres is running on AWS RDS

I found 3 ways to check if the current instance of Postgres is running on AWS select * from pg_settings where name like 'rds.%'; select * from pg_settings where name like 'aurora%'; select spcname from pg_tablespace where spcname like 'aurora%'; Using the first