Re: Postgresql 9.1 replication failing - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Postgresql 9.1 replication failing
Date
Msg-id CA+TgmobFiu9tDy7HFSz=01vxqH_gmAvtPGFg-a_z3M4aigpRkQ@mail.gmail.com
Whole thread Raw
In response to Postgresql 9.1 replication failing  (Jim Buttafuoco <jim@contacttelecom.com>)
List pgsql-hackers
On Thu, Dec 1, 2011 at 1:41 PM, Jim Buttafuoco <jim@contacttelecom.com> wrote:
> 2011-12-01 07:46:30 EST  >LOG:  restored log file "000000010000028E000000E5" from archive
> 2011-12-01 07:46:30 EST  >LOG:  incorrect resource manager data checksum in record at 28E/E555E1B8
>
> Anything I can do on the replica or do I have to start over?

I think you want to rebuild the standby.  Even if you could repair the
damaged WAL record, how can you have any confidence that there is no
other corruption?

Note that rsync has some options to only copy the changed data, which
might greatly accelerated resyncing the standby from the master.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Jim Buttafuoco
Date:
Subject: Postgresql 9.1 replication failing
Next
From: Jerry Sievers
Date:
Subject: Re: Postgresql 9.1 replication failing