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