pg_dump is upset that my max_locks_per_transaction is too low. I've bumped it up several times (up to 600 so far) but
nowsure how many it needs.
I'm merging 90 databases into a single database with 90 schemas. Each schema can have 500'ish tables. Do I need to
setmax_locks_per_transaction to (90*500) 45,000? Will that even work?
Will I ever need to bump up sysctl kernel.shmmax?
Oh, I'm on Slackware 64, PG 9.3.1. I'm trying to get my db from the test box back to the live box. For regular backup
Ithink I'll be switching to streaming replication.
Thanks for your time,
-Andy