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_Restart
At 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
