Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] pg_rewind copy so much data - Mailing list pgsql-general

From Hung Phan
Subject [GENERAL] pg_rewind copy so much data
Date
Msg-id CANHVDh2DEjNg5zmDttzZneKaY0pw94YuN6V6n3wbqfEDOKDrbw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] pg_rewind copy so much data  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
Hi,

I have tested pg_rewind (ver 9.5) with the following scenario:

- one master and one slave (total size of each server is more than 4GB)
- set wal_log_hint=on and restart both
- stop master, promote slave
- start old master again (now two servers have diverged)
- stop old master, run pg_rewind with progress option

The pg_rewind ran successfully but I saw it copied more than 4GB (4265891 kB copied). So I wonder there was very minor difference between two servesr but why did pg_rewind copy almost all data of new master?

Regards,

Hung Phan

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [GENERAL] WAL & ready files retained after turning off log shipping
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] pg_rewind copy so much data