Quick Links

Re: rsync and streaming replication

From:	Jean-Armel Luce <jaluce06(at)gmail(dot)com>
To:	Cédric Villemain <cedric(dot)villemain(dot)debian(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:37:19
Message-ID:	CALnckSp2Ygt7nJBwBX1gRkf6c7ZbEFHS=ydrLsn4cB79Yx_gvw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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

Jal

In response to

Re: rsync and streaming replication at 2011-11-15 20:31:38 from Cédric Villemain

Responses

Re: rsync and streaming replication at 2011-11-16 16:42:34 from Scott Ribe
Re: rsync and streaming replication at 2011-11-16 16:50:43 from Kevin Grittner
Re: rsync and streaming replication at 2011-11-16 16:50:56 from Cédric Villemain

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Scott Ribe	2011-11-16 16:42:34	Re: rsync and streaming replication
Previous Message	Andreas Kretschmer	2011-11-16 16:30:55	Re: How could I find the last modified procedure in the database?