Re: Database corruption in cascaded replica, "pg_xact/003A" doesn't exist, reading as zeroes"

2018-12-05 Thread Achilleas Mantzios
On 5/12/18 4:10 μ.μ., Dejan Petrovic wrote: I believe this is a result of my "broken" procedure for setting up a cascaded replica. I would love to know where the issue is. This is a report of a database corruption which was detected after promoting a replica server to a master server. We suspec

Re: Database corruption in cascaded replica, "pg_xact/003A" doesn't exist, reading as zeroes"

2018-12-05 Thread Stephen Frost
Greetings, * Dejan Petrovic (dejan.petro...@islonline.com) wrote: > I believe this is a result of my "broken" procedure for setting up a > cascaded replica. I would love to know where the issue is. [...] > Notes: > Machines are running on Centos 7, Postgresql 10.2 > DB-1 = master > DB-2 = replic

Database corruption in cascaded replica, "pg_xact/003A" doesn't exist, reading as zeroes"

2018-12-05 Thread Dejan Petrovic
I believe this is a result of my "broken" procedure for setting up a cascaded replica. I would love to know where the issue is. This is a report of a database corruption which was detected after promoting a replica server to a master server. We suspect the actual corruption occurred during rep