On Fri, Mar 29, 2013 at 10:37 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
I used an rsync from the master while both were stopped.
It's newish. I upgraded this pair from 9.1.x to 9.2.3 a little over a week ago, so did a dump/reload and resynced then. It was running happily in between now and then.
Thanks!Quentin Hartman <qhartman@xxxxxxxxxxxxxxxxxxx> writes:What process did you use for setting up the slave?
> Yesterday morning, one of my streaming replication slaves running 9.2.3
> crashed with the following in the log file:
I used an rsync from the master while both were stopped.
This theory would be more probable if it's a relatively new slave, since
any corruption would have been there in the slave's initial state, just
waiting for the replay to run into it.
It's newish. I upgraded this pair from 9.1.x to 9.2.3 a little over a week ago, so did a dump/reload and resynced then. It was running happily in between now and then.
QH
