일단 기배님 말씀대로 확인해 보니 접속이 되네요. 제대로 실행이 되는거 같긴 한데 어떻게 해야하는지를 모르겠어요
마스터쪽 디비에 데이터를 수정하거나 추가하면 자동으로 세컨쪽에 백업이 되고 마스터쪽 디비가 문제있을시 세컨으로 자동 연결이 되는건지 모르겠습니다
그리고 추가로 pgadmin으로 마스터쪽에서 데이터를 수정하거나 추가 삭제해도 되는지?
pgadmin으로 포트 9999로 접속을 할려면 이런 메시지가 뜨더군요..
원래 접속이 되지 않는건지..
에러가 발생하였습니다.
ERROR : kind mismatch between backends
힌트 : check data consistency between master and secondary
서버가 갑자기 연결을 닫았음
이런 처리는 클라이언트의 요구를 처리하는 동안이나 처리하기 전에 서버가 갑자기 종료되었음을 의미함
이렇게 나오구요
freebsd에선
DEBUG: pid 51706: I am 51706 accept fd 6
2009-03-17 11:36:52 DEBUG: pid 51706: Protocol Major: 1234 Minor: 5679 database: user:
2009-03-17 11:36:52 DEBUG: pid 51706: SSLRequest: sent N; retry startup
2009-03-17 11:36:52 DEBUG: pid 51706: Protocol Major: 3 Minor: 0 database: test user: postgres
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 8
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 25
2009-03-17 11:36:52 DEBUG: pid 51706: name: client_encoding value: UTF8
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: client_encoding value: UTF8
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 23
2009-03-17 11:36:52 DEBUG: pid 51706: name: DateStyle value: ISO, MDY
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: DateStyle value: ISO, MDY
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 26
2009-03-17 11:36:52 DEBUG: pid 51706: name: integer_datetimes value: off
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: integer_datetimes value: off
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 20
2009-03-17 11:36:52 DEBUG: pid 51706: name: is_superuser value: on
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: is_superuser value: on
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 25
2009-03-17 11:36:52 DEBUG: pid 51706: name: server_encoding value: UTF8
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: server_encoding value: UTF8
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 25
2009-03-17 11:36:52 DEBUG: pid 51706: name: server_version value: 8.3.1
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: server_version value: 8.3.1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 35
2009-03-17 11:36:52 DEBUG: pid 51706: name: session_authorization value: postgres
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: session_authorization value: postgres
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 36
2009-03-17 11:36:52 DEBUG: pid 51706: name: standard_conforming_strings value: off
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: standard_conforming_strings value: off
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 17
2009-03-17 11:36:52 DEBUG: pid 51706: name: TimeZone value: UTC
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: TimeZone value: ROK
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 12
2009-03-17 11:36:52 DEBUG: pid 51706: pool_send_auth_ok: send pid 53293 to frontend
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 259
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SET DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE datname='test'
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data S len: 171 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: S
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 23
2009-03-17 11:36:52 DEBUG: pid 51706: name: DateStyle value: ISO, MDY
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: DateStyle value: ISO, MDY
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 147 po: 25
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 138 po: 34
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 50 po: 122
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 155
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 167
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: set client_encoding to 'UNICODE'
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data S len: 43 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: S
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length2: master lenghth: 28
2009-03-17 11:36:52 DEBUG: pid 51706: name: client_encoding value: UNICODE
2009-03-17 11:36:52 DEBUG: pid 51706: secondary name: client_encoding value: UNICODE
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 14 po: 30
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 39
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT version();
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 0
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 124 po: 33
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 140
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 152
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince
FROM pg_user WHERE usename=current_user
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 0
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 67 po: 90
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 140
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 152
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user;
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 34 po: 69
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 86
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 98
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
current_setting('default_tablespace') AS default_tablespace
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 544 po: 315
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 449 po: 410
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 357 po: 502
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 229 po: 630
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 105 po: 754
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 842
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 854
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT description FROM pg_shdescription WHERE objoid=27695::oid
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 37
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 49
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SHOW search_path
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 77 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 40 po: 38
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 15 po: 63
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 73
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT nspname, session_user=nspname AS isuser FROM pg_namespace
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 179 po: 58
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 153 po: 84
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 129 po: 108
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 104 po: 133
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 73 po: 164
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 39 po: 198
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 220
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 232
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT description FROM pg_shdescription WHERE objoid=11511::oid
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 0
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 37
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 49
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SHOW search_path
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 77 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 40 po: 38
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 15 po: 63
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 73
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT nspname, session_user=nspname AS isuser FROM pg_namespace
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 179 po: 58
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 153 po: 84
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 129 po: 108
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 104 po: 133
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 73 po: 164
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 39 po: 198
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 220
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 232
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT description FROM pg_shdescription WHERE objoid=11510::oid
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 0
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 37
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 49
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SHOW search_path
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 77 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 40 po: 38
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 15 po: 63
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 73
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT nspname, session_user=nspname AS isuser FROM pg_namespace
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 179 po: 58
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 153 po: 84
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 129 po: 108
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 104 po: 133
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 73 po: 164
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 39 po: 198
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 220
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 232
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT description FROM pg_shdescription WHERE objoid=1::oid
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 0
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 53 po: 37
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 73
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 85
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SHOW search_path
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 77 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 40 po: 38
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 15 po: 63
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 73
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT nspname, session_user=nspname AS isuser FROM pg_namespace
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 179 po: 58
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 153 po: 84
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 129 po: 108
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 104 po: 133
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 73 po: 164
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 39 po: 198
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 220
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 232
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT description FROM pg_shdescription WHERE objoid=32567::oid
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 37
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 49
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SHOW search_path
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 77 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 40 po: 38
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 15 po: 63
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 73
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT nspname, session_user=nspname AS isuser FROM pg_namespace
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 179 po: 58
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 153 po: 84
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 129 po: 108
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 104 po: 133
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 73 po: 164
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 39 po: 198
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 220
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 232
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT ts.oid, spcname, spclocation, pg_get_userbyid(spcowner) as spcuser, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS description FROM pg_tablespace ts
ORDER BY spcname
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 122 po: 166
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 69 po: 219
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 271
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 283
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace
WHERE relname='pga_job' AND nspname='pgagent'
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 29
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 41
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 29 po: 45
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 57
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 69
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT oid, *, pg_catalog.shobj_description(oid, 'pg_authid') AS description FROM pg_authid WHERE NOT rolcanlogin ORDER BY rolname
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 402 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 386
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 398
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
2009-03-17 11:36:52 DEBUG: pid 51706: start_load_balance: selected master is 1
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend T
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 29 po: 45
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data C len: 17 po: 57
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: C
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data Z len: 5 po: 69
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: Z
2009-03-17 11:36:52 DEBUG: pid 51706: pool_read_message_length: lenghth: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: message length: 5
2009-03-17 11:36:52 DEBUG: pid 51706: ReadyForQuery: transaction state: I
2009-03-17 11:36:52 DEBUG: pid 51706: end_load_balance: end load balance mode
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from frontend Q(51)
2009-03-17 11:36:52 DEBUG: pid 51706: statement: SELECT oid, *, pg_catalog.shobj_description(oid, 'pg_authid') AS description FROM pg_authid WHERE rolcanlogin ORDER BY rolname
2009-03-17 11:36:52 DEBUG: pid 51706: waiting for master completing the query
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data T len: 839 po: 1
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: T
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 454 po: 386
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: SimpleForwardToFrontend: length does not match between backends master(122) secondary(121) kind:(D)
2009-03-17 11:36:52 DEBUG: pid 51706: read kind from backend pending data D len: 331 po: 509
2009-03-17 11:36:52 DEBUG: pid 51706: pool_process_query: kind from backend: D
2009-03-17 11:36:52 DEBUG: pid 51706: SimpleForwardToFrontend: length does not match between backends master(122) secondary(76) kind:(D)
2009-03-17 11:36:52 ERROR: pid 51706: pool_process_query: kind does not match between backends master(D) secondary(C)
2009-03-17 11:36:52 LOG: pid 51706: do_child: exits with status 1 due to error
2009-03-17 11:36:52 DEBUG: pid 51694: reap_handler called
2009-03-17 11:36:52 DEBUG: pid 51694: child 51706 exits with status 256 by signal 0
2009-03-17 11:36:52 DEBUG: pid 51694: fork a new child pid 53295
2009-03-17 11:36:52 DEBUG: pid 53295: I am 53295
이렇게 나옵니다 양쪽 디비는 마스터쪽 디비를 백업받아서 똑같이 해뒀구요..
제가 초보라서 많이 힘드네요 혼자서 인터넷 찾아보면서 할려하니..
마스터쪽하고 세컨쪽하고 데이터가 틀린거 같기도 하고 백업을 받자마자 바로 되살려서 똑같이 맞춰뒀는데 이러네요 문제가 어떤건지 조언 좀 부탁드릴께요..
|