Skip site navigation (1) Skip section navigation (2)

BUG #7567: Sequences not properly replicated

From: s(dot)proels(at)pharmatechnik(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7567: Sequences not properly replicated
Date: 2012-09-25 10:13:05
Message-ID: E1TGS8X-0004KK-RU@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7567
Logged by:          Stefan Pröls
Email address:      s(dot)proels(at)pharmatechnik(dot)de
PostgreSQL version: 9.1.3
Operating system:   OpenSUSE 11.4 32-Bit
Description:        

Scenario:
1 Master, 1 Hot-Standby Slave, asynchronous streaming replication, both
servers PostgreSQL 9.1.3.

===Master:================================================================================================================================
$ CREATE SEQUENCE t_seq;

$ SELECT * FROM t_seq;
 sequence_name | last_value | start_value | increment_by |      max_value   
  | min_value | cache_value | log_cnt | is_cycled | is_called 
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 t_seq         |          1 |           1 |            1 |
9223372036854775807 |         1 |           1 |       1 | f         | f

===Slave:=================================================================================================================================
$ SELECT * FROM t_seq;
 sequence_name | last_value | start_value | increment_by |      max_value   
  | min_value | cache_value | log_cnt | is_cycled | is_called 
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 t_seq         |          1 |           1 |            1 |
9223372036854775807 |         1 |           1 |       0 | f         | t

===Master:================================================================================================================================
$ SELECT nextval('t_seq');
 nextval 
---------
       1

$ SELECT * FROM t_seq;
 sequence_name | last_value | start_value | increment_by |      max_value   
  | min_value | cache_value | log_cnt | is_cycled | is_called 
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 t_seq         |          1 |           1 |            1 |
9223372036854775807 |         1 |           1 |       0 | f         | t

===Slave:=================================================================================================================================
$ SELECT * FROM t_seq;
 sequence_name | last_value | start_value | increment_by |      max_value   
  | min_value | cache_value | log_cnt | is_cycled | is_called 
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 t_seq         |          1 |           1 |            1 |
9223372036854775807 |         1 |           1 |       0 | f         | t

===Master:================================================================================================================================
$ SELECT nextval('t_seq');
 nextval 
---------
       2

$ SELECT * FROM t_seq;
 sequence_name | last_value | start_value | increment_by |      max_value   
  | min_value | cache_value | log_cnt | is_cycled | is_called 
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 t_seq         |          2 |           1 |            1 |
9223372036854775807 |         1 |           1 |      32 | f         | t

===Slave:=================================================================================================================================
$ SELECT * FROM t_seq;
 sequence_name | last_value | start_value | increment_by |      max_value   
  | min_value | cache_value | log_cnt | is_cycled | is_called 
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 t_seq         |         34 |           1 |            1 |
9223372036854775807 |         1 |           1 |       0 | f         | t
 



Responses

pgsql-bugs by date

Next:From: Dimitri FontaineDate: 2012-09-25 11:05:55
Subject: Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations
Previous:From: Amit KapilaDate: 2012-09-25 08:35:47
Subject: Re: BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group