Today I tried to promote a slave as master using rsync --checksum (without
doing vacuum freeze) instead of rsync --all.
It takes only 30 minutes with rsync --checksum. Only a few tables are
rsynced. Most of the time is consumed by checksum.
With rsync --all, it takes 1h40 min.
So, rsync --checksum looks better than rsync --all
In response to
pgsql-admin by date
|Next:||From: Scott Ribe||Date: 2011-11-16 16:42:34|
|Subject: Re: rsync and streaming replication|
|Previous:||From: Andreas Kretschmer||Date: 2011-11-16 16:30:55|
|Subject: Re: How could I find the last modified procedure in thedatabase?|