Re: Problems with Binary Replication

[Andreas <maps.on@xxxxxxx>]

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