Re: ShmemAlloc errors

Nick Burrett <nick@dsvr.net> writes:
> $ pg_dumpall >full.db
> pg_dump: WARNING:  ShmemAlloc: out of memory
> pg_dump: Attempt to lock table "vs_dfa554862ac" failed.  ERROR:
> LockAcquire: lock table 1 is out of memory
> pg_dumpall: pg_dump failed on bandwidth, exiting

Looks like you need to increase max_locks_per_transaction in postgresql.conf.
(You'll need to restart the postmaster to make this take effect.)

We don't normally hear of people needing that --- is there anything
unusual about the schema of this database?

            regards, tom lane