Re: Stand by server (9.6.6) with corrupt file

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stand by server (9.6.6) with corrupt file
Date: 2017-12-22 13:42:33
Message-ID: 20171222134233.GP4628@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Edson Carlos Ericksson Richter (richter(at)simkorp(dot)com(dot)br) wrote:
> I was testing our database backup system (based on pgBarman), and
> discovered that one base file is corrupt in our standby database
> server. The file is OK in master server, but has 0 bytes in size in
> standby server.
[...]
> Any advice?

Have you checked if it's an unlogged table?

Thanks!

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Victor 2017-12-22 14:01:24 Why standby restores some WALs many times from archive?
Previous Message Peter Geoghegan 2017-12-22 13:32:10 Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices