Re: ShmemAlloc errors

> > $ 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?

I've bumped into this a few times way back when... any chance the
error message could be improved to include a hint to increase
max_locks_per_transaction?  It took a bit of time digging to figure
out that was a valid solution.  -sc

--
Sean Chittenden