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.
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 |