Now I added 1 row on the master. Before both sequence start values were 403.After the insert the master shows 404 as expected but the "hot-standby" shows 436. In the slaves table there is only the one row more, I just inserted on the master and it's ID column shows 404.
Lets suppose - and hope - at least the data tables stay in sync. But with this phenomena I can't trust the system, can I?and I can't use the hot-standy to pull the backups from there to lighten the load of the master. :(
Am 31.03.2012 21:42, schrieb Andreas:
Hi, I configured a master and a hot-standby server as described here:http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Starting_Replication_with_only_a_Quick_Master_RestartAt first everything looked ok.Then some days later I find that at least some sequences on the hot-standby are higher than those on the master. I checked only one table with such a leaped sequence as primary key and there where no entries for the higher sequence values.How can this happen?
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]