| From: | Jon Erdman <postgresql(at)thewickedtribe(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Chained slaves smaller? |
| Date: | 2017-06-23 19:40:28 |
| Message-ID: | A057D712-C5AA-41F1-BAA4-79115B4986AA@thewickedtribe.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have SR set up in a couple of datacenters, where there’s a master in DC_A with 2 slaves, and a 3rd slave off that master in DC_ B. Also, in DC_B I have 2 slaves chained off the “local master”. Our main database is ~551GB in DC_A and on the replica in B that is subscribed to the real master. However, on one of the chained slaves in DC_B that database is only 484GB. The only thing different about this smaller slave is that it was created by taking a basebackup from the “local master” in DC_B rather than sucking it over the WAN from the true master in DC_A.
This makes no sense to me since I thought SR replicas are bit for bit copies, so I’m somewhat concerned. Any ideas how this could be?
—
Jon Erdman
Postgres Zealot
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2017-06-23 20:37:22 | Re: Chained slaves smaller? |
| Previous Message | Igal @ Lucee.org | 2017-06-23 19:37:10 | Re: Download 9.6.3 Binaries |