I had an issue today where I could not insert into a single table(I think the table was locked).
This was resolved once I revered my application back to hitting the master server for all of my connections.
Is it possible for pgpool to be locking a table and not releasing it until the connection is closed?
Thanks!
pg_terminate_backend
through pgpool (which is all bad). pg_pool sent everything to standby and no inserts/updates worked.