Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Vincent de Phily <vincent.dephily@xxxxxxxxxxxxxxxxx>
Subject: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
From: Michael Nolan <htfoot@xxxxxxxxx>
Date: Fri, 4 May 2012 12:27:40 -0400
Cc: Merlin Moncure <mmoncure@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx, benjamin.vialle@xxxxxxxxxxxxxxxxx
In-reply-to: <2322187.nYELfig9Ab@moltowork>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Streaming replication: sequences on slave seemingly ahead of sequences on master
  - From: Vincent de Phily
- Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
  - From: Merlin Moncure
- Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
  - From: Vincent de Phily

Prev by Date: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Next by Date: .pgpass not working
Previous by thread: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Next by thread: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux