Re: Problems with Binary Replication - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with Binary Replication
Date
Msg-id 27919.1333229938@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with Binary Replication  (Andreas <maps.on@gmx.net>)
Responses Re: Problems with Binary Replication
List pgsql-general
Andreas <maps.on@gmx.net> writes:
> 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.

What are you doing to get it to "show" a value --- not nextval(),
presumably?

I think that this may be the expected behavior from pre-caching of
sequence values.  You would see the same thing on the master if you
were to forcibly crash and restart it.

            regards, tom lane

pgsql-general by date:

Previous
From: Mike Roest
Date:
Subject: Re: pg_dump incredibly slow dumping a single schema from a large db
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: pg_dump incredibly slow dumping a single schema from a large db