Re: PostgreSQL Dump rate is too slow

On Jan 8, 2015, at 4:14 AM, Robert Burgholzer <rburghol(at)vt(dot)edu> wrote:
>
> 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

Don't forget to rsync between pg_start_backup & pg_stop_backup.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice