I've been performing kind of intensive schema dropping and creating over a PostgreSQL server, but now complains..:
WARNING: out of shared memory ERROR: out of shared memory HINT: You might need to increase max_locks_per_transaction.
But the problem remains if PostgreSQL is just restarted with
service postgresql restart, I suspect max_locks_per_transaction won't tune nothing.
I am a bit estranged because the troubleshooting lists for this error is not working for me.
MORE INFO 1409291350: Some details missing but I keep the core SQL result.
postgres=# SELECT version(); PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit
$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.1 LTS Release: 14.04 Codename: trusty