Phil Monroe wrote:
> So we had to failover and do a full base backup to get our slave database back online and ran into a
> interesting scenario. After copying the data directory, setting up the recovery.conf, and starting the
> slave database, the database crashes while replaying xlogs. However, trying to start the database
> again, the database is able to replay xlogs farther than it initially got, but ultimately ended up
> failing out again. After starting the DB a third time, PostgreSQL replays even further and catches up
> to the master to start streaming replication. Is this common and or acceptable?
Certainly not acceptable.
Just checking: When you were "copying the data directory",
did you have online backup mode enabled?
Yours,
Laurenz Albe