On 4 May 2012 14:55, Vincent de Phily <vincent.dephily@xxxxxxxxxxxxxxxxx> wrote: > It all seems to be working fine, except that when checking the data (selecting > latest primary key and sequence value for all tables) on master and slave, > some sequence ids are higher on the slave than on the master. I could > understand if they were lower, but this is weird. > > * The slave's sequences can be anywhere between 1 and 50 ids ahead. This is normal. The sequences are advanced in chunks of 100, so the master's value will be the nextval() while the value on standby will be the start of the next chunk, so as you say, slightly ahead of the master. The same thing would also happen in case of a crash. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
