Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

Responses

pgsql-admin by date

Next:From: Scott RibeDate: 2011-11-16 16:42:34
Subject: Re: rsync and streaming replication
Previous:From: Andreas KretschmerDate: 2011-11-16 16:30:55
Subject: Re: How could I find the last modified procedure in thedatabase?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group