Hot-Standby and sequences - Mailing list pgsql-general

From Wouter D'Haeseleer
Subject Hot-Standby and sequences
Date
Msg-id 1296644632.8673.30.camel@gibralter
Whole thread Raw
List pgsql-general
Hi All,

I have a question about sequences in combination with streaming replication.
It seems something strange is happening with sequences which are streamed to the slave.

When updating the sequence the last_value on the slave shifts with 32 and halts at this value until the master increased the value also with 32.
Is this normal behavior ?

Please see the example below:

Using Setval
----------------------

# psql -t -h master -c "select setval('foo', 10)"
      10

# psql -t -h master  -c "select last_value from foo"
          10

# psql -t -h slave  -c "select last_value from foo"
          10

Using Nextval
----------------------

# psql -t -h master -c "select nextval('foo')"
       11

# psql -t -h master  -c "select last_value from foo"
          11

# psql -t -h slave -c "select last_value from foo"
         43


--
Wouter D'Haeseleer
Linux System Engineer

VASCO Data Security
Dellingstraat 28b
2800 Mechelen
Belgium

phone: +32 15 50 44 00
email: wdh@vasco.com
web: www.vasco.com

pgsql-general by date:

Previous
From: Greg Williamson
Date:
Subject: Re: Importing/Appending to Existing Table
Next
From: Sachin Srivastava
Date:
Subject: Re: Installation Issue of PostgresPlus-9.0