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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Rowan Collins
Дата:
Сообщение: Re: changing port numbers so pgbouncer can read geoserver and postgres
Следующее
От: Patrick Dung
Дата:
Сообщение: Curious question about physical files to store database