Re: Streaming replication: sequences on slave seemingly ahead of sequences on master

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: Vincent de Phily <vincent(dot)dephily(at)mobile-devices(dot)fr>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, benjamin(dot)vialle(at)mobile-devices(dot)fr
Subject: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Date: 2012-05-04 16:27:40
Message-ID: CAOzAquLzW7K-EFByczEPBezmHuCjDVx2c76Ghc1UYG68hHEMiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is due to how sequences are pre-allocated in blocks to sessions
running on the master.

Since the slave is updated via the WALs, and not via 'nextval' function
calls in queries, the sequences that are actually used will remain in sync
with the master.
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rebecca Clarke 2012-05-04 16:30:31 .pgpass not working
Previous Message Vincent de Phily 2012-05-04 16:16:43 Re: Streaming replication: sequences on slave seemingly ahead of sequences on master