On Wed, Oct 12, 2011 at 10:51 PM, Bob Hatfield <bobhatfi...@gmail.com> wrote: >>> Should replication cause corruption on the secondary when stopping/starting >>> the primary? (pg 8.3.12, windows 2008 R2 on both servers) >> >> No, it shouldn't. Any duplicate keys would represent a serious error. >> >> It sounds like you're using warm standby, but when you say run >> pg_start_backup() AFTER each nightly backup I admit to being confused. >> > > Thanks for your response. Perhaps a quick process flow would help clarify: > > Scenario 1 (no errors): > a) create warm standby and let run throughout the day (works great) > b) at the end of the day, trigger the secondary and run a reindex for > testing (no errors) > > Scenario 2 (errors): > a) create warm standby and let run throughout the day (works great) > b) nightly backup: shutdown pg on primary, do a file system copy (for > backup later), start pg again on primary > c) the next morning, trigger the secondary and run a re-index for > testing (ERRORS as described in thread)
I see no reason to expect errors there. Something about your setup is suspect. Disks perhaps. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
