On Jan 8, 2015, at 4:14 AM, Robert Burgholzer <rburghol@xxxxxx> 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@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
