Sequence moves forward when failover is triggerred

From: Andy Chambers <achambers(at)mcna(dot)net>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Sequence moves forward when failover is triggerred
Date: 2012-07-10 22:17:23
Message-ID: CAAfW55oiz6PBBck8=Gs+EY614kYVP0Fj3sPq8uUcSM+vaJZRTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey All,

We used the linked guide to setup streaming replication.

http://wiki.postgresql.org/wiki/Streaming_Replication

When testing the failover procedure, we noticed that when the new master
comes up, some sequences have moved forward (by between 30 and 40). I see
there's a "cache" option when creating the sequence but we're not using
that.

Is this to be expected?

Thanks,
Andy

--
Andy Chambers
Software Engineer
(e) achambers(at)mcna(dot)net
(t) 954-682-0573

CONFIDENTIALITY NOTICE: This electronic mail may contain information that
is privileged, confidential, and/or otherwise protected from disclosure to
anyone other than its intended recipient(s). Any dissemination or use of
this electronic mail or its contents by persons other than the intended
recipient(s) is strictly prohibited. If you have received this
communication in error, please notify the sender immediately by reply
e-mail so that we may correct our internal records. Please then delete the
original message. Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Chambers 2012-07-10 22:26:05 Re: Do I need archive_mode = on for hot standby?
Previous Message Efraín Déctor 2012-07-10 22:16:10 Error with plpython