On Tue, Oct 11, 2011 at 12:12 AM, Bob Hatfield <bobhatfield@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.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services