Re: PostgreSQL Dump rate is too slow - Mailing list pgsql-admin

From Robert Burgholzer
Subject Re: PostgreSQL Dump rate is too slow
Date
Msg-id CACT-NGJrUVp9x9erKio8-4GmiK+=M75ZVYo1Hhr6U-cht9Z+Gw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Dump rate is too slow  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
Responses Re: PostgreSQL Dump rate is too slow
Re: PostgreSQL Dump rate is too slow
List 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 by date:

Previous
From: Harshad Adalkonda
Date:
Subject: Re: PostgreSQL Dump rate is too slow
Next
From: Kieran
Date:
Subject: First point release of 9.4