BUG #7566: Sequences not properly replicated

Поиск
Список
Период
Сортировка
От stefan.proels@pharmatechnik.de
Тема BUG #7566: Sequences not properly replicated
Дата
Msg-id E1TGQFR-00081W-Gf@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      7566
Logged by:          Stefan Pr=C3=B6ls
Email address:      stefan.proels@pharmatechnik.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.

=3D=3D=3DMaster:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ 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

=3D=3D=3DSlave:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ 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

=3D=3D=3DMaster:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ 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

=3D=3D=3DSlave:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ 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

=3D=3D=3DMaster:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ 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

=3D=3D=3DSlave:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ 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
 =

В списке pgsql-bugs по дате отправления:

Предыдущее
От: s.proels@pharmatechnik.de
Дата:
Сообщение: BUG #7567: Sequences not properly replicated
Следующее
От: mcashokkumar@gmail.com
Дата:
Сообщение: BUG #7565: not able to install