Re: PostgreSQL Dump rate is too slow

From: Robert Burgholzer <rburghol(at)vt(dot)edu>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL Dump rate is too slow
Date: 2015-01-08 11:14:12
Message-ID: CACT-NGJrUVp9x9erKio8-4GmiK+=M75ZVYo1Hhr6U-cht9Z+Gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ktm@rice.edu 2015-01-08 13:45:29 Re: PostgreSQL Dump rate is too slow
Previous Message Kieran 2015-01-08 10:19:58 First point release of 9.4