I've used rsync method as described in PostgreSQL wiki.
Database is quite large, and pg_basebackup fail after running for
several hours over a 5Mbps link.
To me, rsync appears to be more reliable over unstable links.
Nevertheless, if some data has been corrupted during copy across the
wire,
El 22/12/17 a las 10:29, Edson Carlos Ericksson Richter escribió:
> Environment: PostgreSQL 9.6.6 installed from yum repository. Oracle
> Linux 7 EL x64. Dell servers with Raid 5 (hw).
>
>
> I was testing our database backup system (based on pgBarman), and
> discovered that one base file is corru
No, it is a normal table.
*Edson Carlos Ericksson Richter*
/SimKorp Ltda/
Fone: (51) 3366-7964
Embedded Image
/"A mente que se abre a uma nova ideia jamais voltará ao seu tamanho
original"/
- Albert Einstein
Em 22/12/2017 11:42, Stephen Frost escreveu:
Greetings,
* Edson Carlos Ericksson
Greetings,
* Edson Carlos Ericksson Richter (rich...@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.
Environment: PostgreSQL 9.6.6 installed from yum repository. Oracle
Linux 7 EL x64. Dell servers with Raid 5 (hw).
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 ha
