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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
