[pgsql-jp: 34489] Re: pgpool 2.3.3 で強制的に縮退運転

[Naoki Kaneto]

金戸です。

> まず状況を確認させていただきたいのですが，psqlのバージョンが7.4.5では
> ないようですが，そういう理解であっていますか？

psql 7.3.4-RH でした。正しくPATHを切って実行したところ、
正常に動作しました。お騒がせしました。

$ psql --version
psql (PostgreSQL) 7.4.5
contains support for command-line editing

$ psql -f recover.txt HOGE hog
DELETE 2
psql:recover.txt:2: ERROR:  duplicate key violates unique constraint "uqt000110"
CONTEXT:  COPY t0001, line 12: "1AMLlB 02 01 test10 test10 テストユーザ 000 1100433 2983"

DEBUG: pid 13130: I am 13130 accept fd 6
DEBUG: pid 13130: Protocol Major: 3 Minor: 0 database: HOGE user: hog
DEBUG: pid 13130: name: client_encoding value: EUC_JP
DEBUG: pid 13130: name: DateStyle value: ISO, MDY
DEBUG: pid 13130: name: is_superuser value: off
DEBUG: pid 13130: name: server_version value: 7.4.5
DEBUG: pid 13130: name: session_authorization value: hog
DEBUG: pid 13130: read kind from backend pending data Z len: 5 po: 153
DEBUG: pid 13130: ReadyForQuery: message length: 5
DEBUG: pid 13130: ReadyForQuery: transaction state: I
DEBUG: pid 13130: read kind from frontend Q(51)
DEBUG: pid 13130: Query: delete from t0001;
DEBUG: pid 13130: read kind from backend C
DEBUG: pid 13130: pool_process_query: waiting for secondary for data ready
DEBUG: pid 13130: read kind from backend pending data Z len: 5 po: 14
DEBUG: pid 13130: ReadyForQuery: message length: 5
DEBUG: pid 13130: ReadyForQuery: transaction state: I
DEBUG: pid 13130: read kind from frontend Q(51)
DEBUG: pid 13130: Query: COPY t0001 FROM STDIN
DEBUG: pid 13130: read kind from backend G
DEBUG: pid 13130: pool_process_query: waiting for secondary for data ready
DEBUG: pid 13130: read kind from backend E
DEBUG: pid 13130: pool_process_query: waiting for secondary for data ready
DEBUG: pid 13130: ReadyForQuery: message length: 5
DEBUG: pid 13130: ReadyForQuery: transaction state: I
DEBUG: pid 13130: read kind from frontend X(58)
DEBUG: pid 13130: Query: RESET ALL
DEBUG: pid 13130: read kind from backend C
DEBUG: pid 13130: read kind from secondary backend C
DEBUG: pid 13130: read kind from backend pending data Z len: 5 po: 11
DEBUG: pid 13130: ReadyForQuery: message length: 5
DEBUG: pid 13130: ReadyForQuery: transaction state: I
DEBUG: pid 13130: pool_connection_pool_timer: called