Postgres Pro
Downloads
Home   >   mailing lists

Re: Streaming replication: sequences on slave seemingly ahead of sequences on master - Mailing list pgsql-general

From Michael Nolan
Subject Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Date
Msg-id CAOzAquLzW7K-EFByczEPBezmHuCjDVx2c76Ghc1UYG68hHEMiA@mail.gmail.com
Whole thread Raw
In response to Re: Streaming replication: sequences on slave seemingly ahead of sequences on master  (Vincent de Phily <vincent.dephily@mobile-devices.fr>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Vincent de Phily
Date:
Subject: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Next
From: Rebecca Clarke
Date:
Subject: .pgpass not working