| From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
|---|---|
| To: | Jean-Armel Luce <jaluce06(at)gmail(dot)com> |
| Cc: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: rsync and streaming replication |
| Date: | 2011-11-16 16:50:56 |
| Message-ID: | CAF6yO=3fjuokv9J80oW9oQWF9YdYxMcH_gSyfJ5KCKwiA5V_5w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
2011/11/16 Jean-Armel Luce <jaluce06(at)gmail(dot)com>:
> Hi,
>
> 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
rsync --all does not exist, you mean --archive I bet (the longopt for
-a, a shorthand for the options below plus -Dt for device/special and
time).
Also you probably want to keep --owner --group --perms --recursive
(or you do file by file with a find or something like that ?)
--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Armel Luce | 2011-11-16 17:11:01 | Re: rsync and streaming replication |
| Previous Message | Kevin Grittner | 2011-11-16 16:50:43 | Re: rsync and streaming replication |