Postgres Pro
Downloads
Home   >   mailing lists

Re: rsync and streaming replication - Mailing list pgsql-admin

From Jean-Armel Luce
Subject Re: rsync and streaming replication
Date
Msg-id CALnckSp2Ygt7nJBwBX1gRkf6c7ZbEFHS=ydrLsn4cB79Yx_gvw@mail.gmail.com
Whole thread Raw
In response to Re: rsync and streaming replication  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: rsync and streaming replication
Re: rsync and streaming replication
Re: rsync and streaming replication
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: David Schnur
Date:
Subject: How and when are encoding DLLs used on Windows?
Next
From: "Kevin Grittner"
Date:
Subject: Re: rsync and streaming replication