Answer the question
In order to leave comments, you need to log in
pgpool II. After failback on nodes different nextval()?
Initial data
Three servers:
s1. Pgpool-II 3.0.1 + PostgreSQL 8.4
s2. PostgreSQL 8.4
s3. PostgreSQL 8.4
In Pgpool-II, replication and balancing mode is enabled, while only servers s1 and s2 are included in balancing by setting weights.
Online-recovery of the PITR type is configured according to the office. manual ( goo.gl/RC2WG).
Description of the problem
On different nodes, when inserting through Pgpool-II, I get different values in the field with modifier nextval ().
More
Table, column of interest:
<br/>
Table "auth.user_temp"<br/>
| Column | Type | Modifiers | Storage | <br/>
| id | integer | not null default nextval('"auth".user_temp_id_seq'::regclass) | plain |<br/>
...<br/>
db=# INSERT INTO "auth"."user_temp" (name, password, last_ip, activation_key, contact_person, id_country, telephone, email, created) VALUES ('user1', '247bad9c4eb5', '127.0.0.1', '228bdcf1', 'FIO', '643', '09090909', '[email protected]', '2011-06-18 01:57:38')<br/>
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question