From: | Subhankar Chattopadhyay <subho(dot)atg(at)gmail(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_basebackup on slave running for a long time |
Date: | 2016-11-21 06:00:36 |
Message-ID: | CAPg1NnGWFP9v+umc2yTr5+VBahevPuNUeTbgHfXg_MMhcgU+ag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi John,
Thanks for reply. In situations where slave is behind master, if I
don't start over, will it catch up automatically?
I am using 9.4 version.
On Mon, Nov 21, 2016 at 11:22 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 11/20/2016 9:29 PM, Subhankar Chattopadhyay wrote:
>>
>> We have setup PostgreSQL master-slave topology with Streaming
>> replication setup.
>> One of the steps for setting up streaming replication is to do
>> pg_basebackup on slave from master.
>>
>> For subsequent update of this database, this step is repeated every
>> time, deleting the existing data copy of slave and running
>> pg_basebackup again.
>>
>> For a huge data size of over 500GB, it takes a lot of time to copy
>> the data from master to slave.
>> We were looking for some optimization technique so that it doesnt have
>> to copy the whole data in every update of the system.
>>
>> Is there a way to do that? Can somebody throw some light on this?
>
>
> if you have streaming replication, why do you delete it and start over ??!?
>
> the streaming replication should replicate all updates of the master in near
> realtime to the slave(s).
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
Subhankar Chattopadhyay
Bangalore, India
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-11-21 06:12:49 | Re: pg_basebackup on slave running for a long time |
Previous Message | John R Pierce | 2016-11-21 05:52:49 | Re: pg_basebackup on slave running for a long time |