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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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