PostgreSQL error code
PostgreSQL error 55P02
55P02 is the SQLSTATE PostgreSQL reports for cant change runtime param, in class 55, Object Not In Prerequisite State.
| SQLSTATE | 55P02 |
|---|---|
| Condition name | cant_change_runtime_param |
| Class | 55 — Object Not In Prerequisite State |
Reproduce it, then fix it
shared_buffers is set when the server starts. Change it in postgresql.conf, or with ALTER SYSTEM, and restart. Settings like work_mem can be changed per session. Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
SET shared_buffers = '1GB';
SET work_mem = '64MB';