Re: PostgreSQL Dump rate is too slow

Поиск
Список
Период
Сортировка
От Robert Burgholzer
Тема Re: PostgreSQL Dump rate is too slow
Дата
Msg-id CACT-NGJrUVp9x9erKio8-4GmiK+=M75ZVYo1Hhr6U-cht9Z+Gw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Dump rate is too slow  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
Ответы Re: PostgreSQL Dump rate is too slow
Re: PostgreSQL Dump rate is too slow
Список pgsql-admin
To elaborate, I have found the rsync used in my (most?) streaming replication setups is 10x or more faster than pg_dump.  If your job specs required a pg_dump output file it would be fairly simple to do the following (moree or less):
1. setup a replicant (even on the same machine but different drive if you wanted)
2. make sure the replicant is off
3. rsync the data dir to the replicant
4. turn on the replicant
5. execute pg_dump on the replicant

regards,
/r/b

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

Предыдущее
От: Harshad Adalkonda
Дата:
Сообщение: Re: PostgreSQL Dump rate is too slow
Следующее
От: Kieran
Дата:
Сообщение: First point release of 9.4