Shared WAL archive between master and standby: WALs not always identical

From: Sasa Vilic <sasavilic(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Shared WAL archive between master and standby: WALs not always identical
Date: 2017-02-28 00:40:21
Message-ID: CAOJhpYdJioGkS1-puGC911nmneet_Eq=F86wp6v8C7G2W8bO8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hallo,

I am trying to setup shared WAL archive between master and standby. Standby
is synchronously streaming from master and both servers run with
archive_mode = always. The ideas is that when promoting standby to master
we would not missed WALs.

My problem is that sometimes WAL uploaded from master and from slave are
not 100% identical. In most cases they are but occasionally they are not. I
have written small script that ensures that upload is free of race
condition and I log md5 sum of each WAL. Aren't WALs from master and
standby supposed to be identical? After all, standby is just consuming WAL
that it is receiving from master ...

Or do you have any better suggestion on how to achieve continuous
incremental backup?

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-02-28 00:57:55 Re: Shared WAL archive between master and standby: WALs not always identical
Previous Message Nathan Stocks 2017-02-28 00:00:48 Re: Conferences for a DBA?