[pgpool-general-jp: 24] Re: JDBCからpgpool-IIを経由してのpostgreSQL接続について

[高橋 浩之]

高橋です。

すみません。添付されなかったので再送します。

----pgpool-IIのログ----

2006-11-09 19:28:26 JST myhost postgres[9289]: [1-1] LOG:  00000:
statement: PREPARE <unnamed> AS SELECT * FROM test
2006-11-09 19:28:26 JST myhost postgres[9289]: [2-1] LOCATION:
exec_parse_message, postgres.c:1153
2006-11-09 19:28:26 JST myhost postgres[9289]: [3-1] LOG:  00000:
statement: <BIND>
2006-11-09 19:28:26 JST myhost postgres[9289]: [4-1] LOCATION:
exec_bind_message, postgres.c:1454

----pgpool-IIのログ ここまで----


----postgreSQLのログ----

2006-11-09 19:28:26 DEBUG: pid 9281: I am 9281 accept fd 7
2006-11-09 19:28:26 DEBUG: pid 9281: Protocol Major: 3 Minor: 0
database: test user: postgres
2006-11-09 19:28:26 DEBUG: pid 9281: new_connection: connecting 0
backend
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length: slot: 0
length: 8
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 28
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name: client_encoding
value: UNICODE
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 23
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name: DateStyle
value: ISO, MDY
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 26
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name:
integer_datetimes value: off
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 20
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name: is_superuser
value: on
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 25
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name: server_encoding
value: UTF8
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 25
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name: server_version
value: 8.1.4
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 35
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name:
session_authorization value: postgres
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 36
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name:
standard_conforming_strings value: off
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length2: master
slot: 0 length: 19
2006-11-09 19:28:26 DEBUG: pid 9281: 0 th backend: name: TimeZone value:
Japan
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length: slot: 0
length: 12
2006-11-09 19:28:26 DEBUG: pid 9281: pool_send_auth_ok: send pid 9289 to
frontend
2006-11-09 19:28:26 DEBUG: pid 9281: read_kind_from_backend: read kind
from 0 th backend Z NUM_BACKENDS: 1
2006-11-09 19:28:26 DEBUG: pid 9281: pool_process_query: kind from
backend: Z
2006-11-09 19:28:26 DEBUG: pid 9281: pool_read_message_length: slot: 0
length: 5
2006-11-09 19:28:26 DEBUG: pid 9281: ReadyForQuery: message length: 5
2006-11-09 19:28:26 DEBUG: pid 9281: ReadyForQuery: transaction state: I
2006-11-09 19:28:26 DEBUG: pid 9281: pool_process_query: num_fds: 9
2006-11-09 19:28:26 DEBUG: pid 9281: read kind from frontend P(50)
2006-11-09 19:28:26 DEBUG: pid 9281: read_kind_from_backend: read kind
from 0 th backend 1 NUM_BACKENDS: 1
2006-11-09 19:28:26 DEBUG: pid 9281: read kind from frontend B(42)

----postgreSQLのログ ここまで----