pgpool이 좋다고 해서 멋도 모르고 그냥 설치는 해 봤는데, 사실
머가 좋은지 잘 모르겠네요.
아래 내용대로인데, 이렇게만 하면 잘 돌아가고 있는 건가요?
pgpool을 왜 사용하는지 관련 글을 읽어 보아도 잘 이해가
안갑니다.
pgpool을 왜 사용하며 아무 곳에나 막 사용해도 전혀 문제가
발생하지 않는지 알고 싶습니다.
pgpool이 좋긴 좋은거죠?
친절한 답변에 미리 감사 드립니다.
postgres@www(19)[~]% psql -U
postgres -p 9999 -c 'show pool_status' exleague
item | value | description
------------------------------+------------------------------------------------------+------------------------------------------
listen_addresses | localhost | host name(s) or IP address(es) to
list en to
port | 9999 | pgpool accepting port number
socket_dir | /tmp | pgpool socket directory
backend_host_name | | master backend host name
backend_port | 5432 | master backend port number
secondary_backend_host_name | | secondary backend host name
secondary_backend_port | 0 | secondary backend port number
num_init_children | 32 | # of children initially pre-forked
child_life_time | 300 | if idle for this seconds, child exits
connection_life_time | 0 | if idle for this seconds, connection c
loses
child_max_connections | 0 | if max_connections received, chile exi
ts
max_pool | 4 | max # of connection pool per child
logdir | /tmp | logging directory
backend_socket_dir | /tmp | Unix domain socket directory for
the
replication_mode | 0 | non 0 if operating in replication modebyte
2135
item | value | description
------------------------------+------------------------------------------------------+------------------------------------------
listen_addresses | localhost | host name(s) or IP address(es) to
listen to
port | 9999 | pgpool accepting port number
socket_dir | /tmp | pgpool socket directory
backend_host_name | | master backend host name
backend_port | 5432 | master backend port number
secondary_backend_host_name | | secondary backend host name
secondary_backend_port | 0 | secondary backend port number
num_init_children | 32 | # of children initially pre-forked
child_life_time | 300 | if idle for this seconds, child exits
connection_life_time | 0 | if idle for this seconds, connection
closes
child_max_connections | 0 | if max_connections received, chile
exits
max_pool | 4 | max # of connection pool per child
logdir | /tmp | logging directory
backend_socket_dir | /tmp | Unix domain socket directory for the
PostgreSQL server
replication_mode | 0 | non 0 if operating in replication mode
replication_strict | 1 | non 0 if operating in strict mode
replication_timeout | 5000 | if secondary does not respond in this
milli seconds, abort the session
load_balance_mode | 0 | non 0 if operating in load balancing
mode
weight_master | 0.500000 | weight of master
weight_secondary | 0.500000 | weight of secondary
replication_stop_on_mismatch | 0 | stop replication mode on fatal
error
reset_query_list | ABORT; | queries issued at the end of
session
print_timestamp | 1 | if true print time stamp to each log
line
master_slave_mode | 0 | if true, operate in master/slave mode
connection_cache | 1 | if true, cache connection pool
health_check_timeout | 20 | health check timeout
health_check_period | 0 | health check period
health_check_user | nobody | health check user
insert_lock | 0 | insert lock
ignore_leading_white_space | 0 | ignore leading white spaces
current_backend_host_name | | current master host name
current_backend_port | 5432 | current master port #
replication_enabled | 0 | non 0 if actually operating in
replication mode
master_slave_enabled | 0 | non 0 if actually operating in
master/slave
num_reset_queries | 3 | number of queries in reset_query_list
server_status | master( on 5432) up secondary( on 0) unused |
server status
(36 rows)
~
|