Re: Problems with Binary Replication

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with Binary Replication
Date: 2012-03-31 21:38:58
Message-ID: 27919.1333229938@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas <maps(dot)on(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-03-31 21:44:05 Re: [HACKERS] Re: pg_dump incredibly slow dumping a single schema from a large db
Previous Message Mike Roest 2012-03-31 20:54:23 Re: pg_dump incredibly slow dumping a single schema from a large db