Re: Problems with Binary Replication

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?
>
>