"Robert Frantz" <rfrantz@cognitronix.com> writes:
> I was able to backup this server using PGAdmin in postgresql 8.4 but now
> that I've migrated to 9.0, I get:
> pg_dump: Error message from server: ERROR: out of shared memory
> HINT: You might need to increase max_locks_per_transaction.
> I have tried increasing max_locks_per_transaction first to 1500, then 10000
> and then 50000 with no success.
That should fix it. Did you remember to restart the server after
adjusting the config file entry? ("pg_ctl reload" won't do.)
You can verify the active value with "SHOW max_locks_per_transaction".
regards, tom lane
