pg_dump with lots and lots of tables

Поиск
Список
Период
Сортировка
От Andy Colson
Тема pg_dump with lots and lots of tables
Дата
Msg-id 527526AA.6040304@squeakycode.net
обсуждение исходный текст
Ответы Re: pg_dump with lots and lots of tables
Список pgsql-general
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


В списке pgsql-general по дате отправления: