Postgres Pro
Downloads
Home   >   mailing lists

Re: Stand by server (9.6.6) with corrupt file - Mailing list pgsql-general

From Stephen Frost
Subject Re: Stand by server (9.6.6) with corrupt file
Date
Msg-id 20171222134233.GP4628@tamriel.snowman.net
Whole thread Raw
In response to Stand by server (9.6.6) with corrupt file  (Edson Carlos Ericksson Richter <richter@simkorp.com.br>)
Responses Re: Stand by server (9.6.6) with corrupt file
List pgsql-general
Tree view 
Greetings,

* Edson Carlos Ericksson Richter (richter@simkorp.com.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
Attachment

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Next
From: Victor
Date:
Subject: Why standby restores some WALs many times from archive?