API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
141
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.19 KB | None | 0 0
raw download clone embed print report
  1. # ----------------------------
  2. # pgPool-II configuration file
  3. # ----------------------------
  4. #
  5. # This file consists of lines of the form:
  6. #
  7. # name = value
  8. #
  9. # Whitespace may be used. Comments are introduced with "#" anywhere on a line.
  10. # The complete list of parameter names and allowed values can be found in the
  11. # pgPool-II documentation.
  12. #
  13. # This file is read on server startup and when the server receives a SIGHUP
  14. # signal. If you edit the file on a running system, you have to SIGHUP the
  15. # server for the changes to take effect, or use "pgpool reload". Some
  16. # parameters, which are marked below, require a server shutdown and restart to
  17. # take effect.
  18. #
  19.  
  20.  
  21. #------------------------------------------------------------------------------
  22. # CONNECTIONS
  23. #------------------------------------------------------------------------------
  24.  
  25. # - pgpool Connection Settings -
  26.  
  27. listen_addresses = '*'
  28. # Host name or IP address to listen on:
  29. # '*' for all, '' for no TCP/IP connections
  30. # (change requires restart)
  31. port = 9999
  32. # Port number
  33. # (change requires restart)
  34. socket_dir = '/var/run/postgresql'
  35. # Unix domain socket path
  36. # The Debian package defaults to
  37. # /var/run/postgresql
  38. # (change requires restart)
  39. listen_backlog_multiplier = 2
  40. # Set the backlog parameter of listen(2) to
  41. # num_init_children * listen_backlog_multiplier.
  42. # (change requires restart)
  43. serialize_accept = off
  44. # whether to serialize accept() call to avoid thundering herd problem
  45. # (change requires restart)
  46.  
  47. # - pgpool Communication Manager Connection Settings -
  48.  
  49. pcp_listen_addresses = '*'
  50. # Host name or IP address for pcp process to listen on:
  51. # '*' for all, '' for no TCP/IP connections
  52. # (change requires restart)
  53. pcp_port = 9898
  54. # Port number for pcp
  55. # (change requires restart)
  56. pcp_socket_dir = '/var/run/postgresql'
  57. # Unix domain socket path for pcp
  58. # The Debian package defaults to
  59. # /var/run/postgresql
  60. # (change requires restart)
  61.  
  62. # - Backend Connection Settings -
  63. backend_hostname0 = 'pgsql001'
  64. backend_port0 = 5432
  65. backend_weight0 = 1
  66. backend_data_directory0 = '/var/lib/pgsql/9.4/data'
  67. backend_flag0 = 'ALLOW_TO_FAILOVER'
  68.  
  69. backend_hostname1 = 'pgsql002'
  70. backend_port1 = 5432
  71. backend_weight1 = 1
  72. backend_data_directory1 = '/var/lib/pgsql/9.4/data'
  73. backend_flag1 = 'ALLOW_TO_FAILOVER'
  74.  
  75. backend_hostname2 = 'pgsql003'
  76. backend_port2 = 5432
  77. backend_weight2 = 1
  78. backend_data_directory2 = '/var/lib/pgsql/9.4/data'
  79. backend_flag2 = 'ALLOW_TO_FAILOVER'
  80.  
  81.  
  82.  
  83. # - Authentication -
  84.  
  85. enable_pool_hba = on
  86. # Use pool_hba.conf for client authentication
  87. pool_passwd = 'pool_passwd'
  88. # File name of pool_passwd for md5 authentication.
  89. # "" disables pool_passwd.
  90. # (change requires restart)
  91. authentication_timeout = 60
  92. # Delay in seconds to complete client authentication
  93. # 0 means no timeout.
  94.  
  95. # - SSL Connections -
  96.  
  97. ssl = off
  98. # Enable SSL support
  99. # (change requires restart)
  100. #ssl_key = './server.key'
  101. # Path to the SSL private key file
  102. # (change requires restart)
  103. #ssl_cert = './server.cert'
  104. # Path to the SSL public certificate file
  105. # (change requires restart)
  106. #ssl_ca_cert = ''
  107. # Path to a single PEM format file
  108. # containing CA root certificate(s)
  109. # (change requires restart)
  110. #ssl_ca_cert_dir = ''
  111. # Directory containing CA root certificate(s)
  112. # (change requires restart)
  113.  
  114.  
  115. #------------------------------------------------------------------------------
  116. # POOLS
  117. #------------------------------------------------------------------------------
  118.  
  119. # - Concurrent session and pool size -
  120.  
  121. num_init_children = 32
  122. # Number of concurrent sessions allowed
  123. # (change requires restart)
  124. max_pool = 4
  125. # Number of connection pool caches per connection
  126. # (change requires restart)
  127.  
  128. # - Life time -
  129.  
  130. child_life_time = 300
  131. # Pool exits after being idle for this many seconds
  132. child_max_connections = 0
  133. # Pool exits after receiving that many connections
  134. # 0 means no exit
  135. connection_life_time = 0
  136. # Connection to backend closes after being idle for this many seconds
  137. # 0 means no close
  138. client_idle_limit = 0
  139. # Client is disconnected after being idle for that many seconds
  140. # (even inside an explicit transactions!)
  141. # 0 means no disconnection
  142.  
  143.  
  144. #------------------------------------------------------------------------------
  145. # LOGS
  146. #------------------------------------------------------------------------------
  147.  
  148. # - Where to log -
  149.  
  150. log_destination = 'stderr,syslog'
  151. # Where to log
  152. # Valid values are combinations of stderr,
  153. # and syslog. Default to stderr.
  154.  
  155. # - What to log -
  156.  
  157. log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line.
  158.  
  159. log_connections = on
  160. # Log connections
  161. log_hostname = on
  162. # Hostname will be shown in ps status
  163. # and in logs if connections are logged
  164. log_statement = on
  165. # Log all statements
  166. log_per_node_statement = on
  167. # Log all statements
  168. # with node and backend informations
  169. log_standby_delay = 'none'
  170. # Log standby delay
  171. # Valid values are combinations of always,
  172. # if_over_threshold, none
  173.  
  174. # - Syslog specific -
  175.  
  176. syslog_facility = 'LOCAL0'
  177. # Syslog local facility. Default to LOCAL0
  178. syslog_ident = 'pgpool'
  179. # Syslog program identification string
  180. # Default to 'pgpool'
  181.  
  182. # - Debug -
  183.  
  184. log_error_verbosity = default # terse, default, or verbose messages
  185.  
  186. client_min_messages = notice # values in order of decreasing detail:
  187. # debug5
  188. # debug4
  189. # debug3
  190. # debug2
  191. # debug1
  192. # log
  193. # notice
  194. # warning
  195. # error
  196.  
  197. log_min_messages = warning # values in order of decreasing detail:
  198. # debug5
  199. # debug4
  200. # debug3
  201. # debug2
  202. # debug1
  203. # info
  204. # notice
  205. # warning
  206. # error
  207. # log
  208. # fatal
  209. # panic
  210.  
  211. #------------------------------------------------------------------------------
  212. # FILE LOCATIONS
  213. #------------------------------------------------------------------------------
  214.  
  215. pid_file_name = '/var/run/pgpool/pgpool.pid'
  216. # PID file name
  217. # (change requires restart)
  218. logdir = '/var/log/pgpool'
  219. # Directory of pgPool status file
  220. # (change requires restart)
  221.  
  222.  
  223. #------------------------------------------------------------------------------
  224. # CONNECTION POOLING
  225. #------------------------------------------------------------------------------
  226.  
  227. connection_cache = on
  228. # Activate connection pools
  229. # (change requires restart)
  230.  
  231. # Semicolon separated list of queries
  232. # to be issued at the end of a session
  233. # The default is for 8.3 and later
  234. reset_query_list = 'ABORT; DISCARD ALL'
  235. # The following one is for 8.2 and before
  236. #reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
  237.  
  238.  
  239. #------------------------------------------------------------------------------
  240. # REPLICATION MODE
  241. #------------------------------------------------------------------------------
  242.  
  243. replication_mode = off
  244. # Activate replication mode
  245. # (change requires restart)
  246. replicate_select = off
  247. # Replicate SELECT statements
  248. # when in replication mode
  249. # replicate_select is higher priority than
  250. # load_balance_mode.
  251.  
  252. insert_lock = off
  253. # Automatically locks a dummy row or a table
  254. # with INSERT statements to keep SERIAL data
  255. # consistency
  256. # Without SERIAL, no lock will be issued
  257. lobj_lock_table = ''
  258. # When rewriting lo_creat command in
  259. # replication mode, specify table name to
  260. # lock
  261.  
  262. # - Degenerate handling -
  263.  
  264. replication_stop_on_mismatch = off
  265. # On disagreement with the packet kind
  266. # sent from backend, degenerate the node
  267. # which is most likely "minority"
  268. # If off, just force to exit this session
  269.  
  270. failover_if_affected_tuples_mismatch = off
  271. # On disagreement with the number of affected
  272. # tuples in UPDATE/DELETE queries, then
  273. # degenerate the node which is most likely
  274. # "minority".
  275. # If off, just abort the transaction to
  276. # keep the consistency
  277.  
  278.  
  279. #------------------------------------------------------------------------------
  280. # LOAD BALANCING MODE
  281. #------------------------------------------------------------------------------
  282.  
  283. load_balance_mode = on
  284. # Activate load balancing mode
  285. # (change requires restart)
  286. ignore_leading_white_space = on
  287. # Ignore leading white spaces of each query
  288. white_function_list = ''
  289. # Comma separated list of function names
  290. # that don't write to database
  291. # Regexp are accepted
  292. black_function_list = 'currval,lastval,nextval,setval'
  293. # Comma separated list of function names
  294. # that write to database
  295. # Regexp are accepted
  296.  
  297. database_redirect_preference_list = ''
  298. # comma separated list of pairs of database and node id.
  299. # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
  300. # valid for streaming replicaton mode only.
  301.  
  302. app_name_redirect_preference_list = ''
  303. # comma separated list of pairs of app name and node id.
  304. # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
  305. # valid for streaming replicaton mode only.
  306. allow_sql_comments = off
  307. # if on, ignore SQL comments when judging if load balance or
  308. # query cache is possible.
  309. # If off, SQL comments effectively prevent the judgment
  310. # (pre 3.4 behavior).
  311.  
  312. #------------------------------------------------------------------------------
  313. # MASTER/SLAVE MODE
  314. #------------------------------------------------------------------------------
  315.  
  316. master_slave_mode = on
  317. # Activate master/slave mode
  318. # (change requires restart)
  319. master_slave_sub_mode = 'slony'
  320. # Master/slave sub mode
  321. # Valid values are combinations slony or
  322. # stream. Default is slony.
  323. # (change requires restart)
  324.  
  325. # - Streaming -
  326.  
  327. sr_check_period = 0
  328. # Streaming replication check period
  329. # Disabled (0) by default
  330. sr_check_user = 'nobody'
  331. # Streaming replication check user
  332. # This is necessary even if you disable
  333. # streaming replication delay check with
  334. # sr_check_period = 0
  335. sr_check_password = ''
  336. # Password for streaming replication check user
  337. sr_check_database = 'postgres'
  338. # Database name for streaming replication check
  339. delay_threshold = 0
  340. # Threshold before not dispatching query to standby node
  341. # Unit is in bytes
  342. # Disabled (0) by default
  343.  
  344. # - Special commands -
  345.  
  346. follow_master_command = ''
  347. # Executes this command after master failover
  348. # Special values:
  349. # %d = node id
  350. # %h = host name
  351. # %p = port number
  352. # %D = database cluster path
  353. # %m = new master node id
  354. # %H = hostname of the new master node
  355. # %M = old master node id
  356. # %P = old primary node id
  357. # %r = new master port number
  358. # %R = new master database cluster path
  359. # %% = '%' character
  360.  
  361. #------------------------------------------------------------------------------
  362. # HEALTH CHECK
  363. #------------------------------------------------------------------------------
  364.  
  365. health_check_period = 0
  366. # Health check period
  367. # Disabled (0) by default
  368. health_check_timeout = 20
  369. # Health check timeout
  370. # 0 means no timeout
  371. health_check_user = 'nobody'
  372. # Health check user
  373. health_check_password = ''
  374. # Password for health check user
  375. health_check_database = ''
  376. # Database name for health check. If '', tries 'postgres' frist, then 'template1'
  377.  
  378. health_check_max_retries = 0
  379. # Maximum number of times to retry a failed health check before giving up.
  380. health_check_retry_delay = 1
  381. # Amount of time to wait (in seconds) between retries.
  382. connect_timeout = 10000
  383. # Timeout value in milliseconds before giving up to connect to backend.
  384. # Default is 10000 ms (10 second). Flaky network user may want to increase
  385. # the value. 0 means no timeout.
  386. # Note that this value is not only used for health check,
  387. # but also for ordinary conection to backend.
  388.  
  389. #------------------------------------------------------------------------------
  390. # FAILOVER AND FAILBACK
  391. #------------------------------------------------------------------------------
  392.  
  393. failover_command = ''
  394. # Executes this command at failover
  395. # Special values:
  396. # %d = node id
  397. # %h = host name
  398. # %p = port number
  399. # %D = database cluster path
  400. # %m = new master node id
  401. # %H = hostname of the new master node
  402. # %M = old master node id
  403. # %P = old primary node id
  404. # %r = new master port number
  405. # %R = new master database cluster path
  406. # %% = '%' character
  407. failback_command = ''
  408. # Executes this command at failback.
  409. # Special values:
  410. # %d = node id
  411. # %h = host name
  412. # %p = port number
  413. # %D = database cluster path
  414. # %m = new master node id
  415. # %H = hostname of the new master node
  416. # %M = old master node id
  417. # %P = old primary node id
  418. # %r = new master port number
  419. # %R = new master database cluster path
  420. # %% = '%' character
  421.  
  422. fail_over_on_backend_error = on
  423. # Initiates failover when reading/writing to the
  424. # backend communication socket fails
  425. # If set to off, pgpool will report an
  426. # error and disconnect the session.
  427.  
  428. search_primary_node_timeout = 300
  429. # Timeout in seconds to search for the
  430. # primary node when a failover occurs.
  431. # 0 means no timeout, keep searching
  432. # for a primary node forever.
  433.  
  434. #------------------------------------------------------------------------------
  435. # ONLINE RECOVERY
  436. #------------------------------------------------------------------------------
  437.  
  438. recovery_user = 'nobody'
  439. # Online recovery user
  440. recovery_password = ''
  441. # Online recovery password
  442. recovery_1st_stage_command = ''
  443. # Executes a command in first stage
  444. recovery_2nd_stage_command = ''
  445. # Executes a command in second stage
  446. recovery_timeout = 90
  447. # Timeout in seconds to wait for the
  448. # recovering node's postmaster to start up
  449. # 0 means no wait
  450. client_idle_limit_in_recovery = 0
  451. # Client is disconnected after being idle
  452. # for that many seconds in the second stage
  453. # of online recovery
  454. # 0 means no disconnection
  455. # -1 means immediate disconnection
  456.  
  457.  
  458. #------------------------------------------------------------------------------
  459. # WATCHDOG
  460. #------------------------------------------------------------------------------
  461.  
  462. # - Enabling -
  463.  
  464. use_watchdog = off
  465. # Activates watchdog
  466. # (change requires restart)
  467.  
  468. # -Connection to up stream servers -
  469.  
  470. trusted_servers = ''
  471. # trusted server list which are used
  472. # to confirm network connection
  473. # (hostA,hostB,hostC,...)
  474. # (change requires restart)
  475. ping_path = '/bin'
  476. # ping command path
  477. # (change requires restart)
  478.  
  479. # - Watchdog communication Settings -
  480.  
  481. wd_hostname = ''
  482. # Host name or IP address of this watchdog
  483. # (change requires restart)
  484. wd_port = 9000
  485. # port number for watchdog service
  486. # (change requires restart)
  487. wd_priority = 1
  488. # priority of this watchdog in leader election
  489. # (change requires restart)
  490.  
  491. wd_authkey = ''
  492. # Authentication key for watchdog communication
  493. # (change requires restart)
  494.  
  495. wd_ipc_socket_dir = '/var/run/postgresql'
  496. # Unix domain socket path for watchdog IPC socket
  497. # The Debian package defaults to
  498. # /var/run/postgresql
  499. # (change requires restart)
  500.  
  501.  
  502. # - Virtual IP control Setting -
  503.  
  504. delegate_IP = ''
  505. # delegate IP address
  506. # If this is empty, virtual IP never bring up.
  507. # (change requires restart)
  508. if_cmd_path = '/sbin'
  509. # path to the directory where if_up/down_cmd exists
  510. # (change requires restart)
  511. if_up_cmd = 'ip addr add $_IP_$/24 dev eth0 label eth0:0'
  512. # startup delegate IP command
  513. # (change requires restart)
  514. if_down_cmd = 'ip addr del $_IP_$/24 dev eth0'
  515. # shutdown delegate IP command
  516. # (change requires restart)
  517. arping_path = '/usr/sbin'
  518. # arping command path
  519. # (change requires restart)
  520. arping_cmd = 'arping -U $_IP_$ -w 1'
  521. # arping command
  522. # (change requires restart)
  523.  
  524. # - Behaivor on escalation Setting -
  525.  
  526. clear_memqcache_on_escalation = on
  527. # Clear all the query cache on shared memory
  528. # when standby pgpool escalate to active pgpool
  529. # (= virtual IP holder).
  530. # This should be off if client connects to pgpool
  531. # not using virtual IP.
  532. # (change requires restart)
  533. wd_escalation_command = ''
  534. # Executes this command at escalation on new active pgpool.
  535. # (change requires restart)
  536. wd_de_escalation_command = ''
  537. # Executes this command when master pgpool resigns from being master.
  538. # (change requires restart)
  539.  
  540. # - Lifecheck Setting -
  541.  
  542. # -- common --
  543.  
  544. wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.
  545. # if any interface from the list is active the watchdog will
  546. # consider the network is fine
  547. # 'any' to enable monitoring on all interfaces except loopback
  548. # '' to disable monitoring
  549.  
  550.  
  551. wd_lifecheck_method = 'heartbeat'
  552. # Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')
  553. # (change requires restart)
  554. wd_interval = 10
  555. # lifecheck interval (sec) > 0
  556. # (change requires restart)
  557.  
  558. # -- heartbeat mode --
  559.  
  560. wd_heartbeat_port = 9694
  561. # Port number for receiving heartbeat signal
  562. # (change requires restart)
  563. wd_heartbeat_keepalive = 2
  564. # Interval time of sending heartbeat signal (sec)
  565. # (change requires restart)
  566. wd_heartbeat_deadtime = 30
  567. # Deadtime interval for heartbeat signal (sec)
  568. # (change requires restart)
  569. heartbeat_destination0 = 'host0_ip1'
  570. # Host name or IP address of destination 0
  571. # for sending heartbeat signal.
  572. # (change requires restart)
  573. heartbeat_destination_port0 = 9694
  574. # Port number of destination 0 for sending
  575. # heartbeat signal. Usually this is the
  576. # same as wd_heartbeat_port.
  577. # (change requires restart)
  578. heartbeat_device0 = ''
  579. # Name of NIC device (such like 'eth0')
  580. # used for sending/receiving heartbeat
  581. # signal to/from destination 0.
  582. # This works only when this is not empty
  583. # and pgpool has root privilege.
  584. # (change requires restart)
  585.  
  586. #heartbeat_destination1 = 'host0_ip2'
  587. #heartbeat_destination_port1 = 9694
  588. #heartbeat_device1 = ''
  589.  
  590. # -- query mode --
  591.  
  592. wd_life_point = 3
  593. # lifecheck retry times
  594. # (change requires restart)
  595. wd_lifecheck_query = 'SELECT 1'
  596. # lifecheck query to pgpool from watchdog
  597. # (change requires restart)
  598. wd_lifecheck_dbname = 'template1'
  599. # Database name connected for lifecheck
  600. # (change requires restart)
  601. wd_lifecheck_user = 'nobody'
  602. # watchdog user monitoring pgpools in lifecheck
  603. # (change requires restart)
  604. wd_lifecheck_password = ''
  605. # Password for watchdog user in lifecheck
  606. # (change requires restart)
  607.  
  608. # - Other pgpool Connection Settings -
  609.  
  610. #other_pgpool_hostname0 = 'host0'
  611. # Host name or IP address to connect to for other pgpool 0
  612. # (change requires restart)
  613. #other_pgpool_port0 = 5432
  614. # Port number for othet pgpool 0
  615. # (change requires restart)
  616. #other_wd_port0 = 9000
  617. # Port number for othet watchdog 0
  618. # (change requires restart)
  619. #other_pgpool_hostname1 = 'host1'
  620. #other_pgpool_port1 = 5432
  621. #other_wd_port1 = 9000
  622.  
  623.  
  624. #------------------------------------------------------------------------------
  625. # OTHERS
  626. #------------------------------------------------------------------------------
  627. relcache_expire = 0
  628. # Life time of relation cache in seconds.
  629. # 0 means no cache expiration(the default).
  630. # The relation cache is used for cache the
  631. # query result against PostgreSQL system
  632. # catalog to obtain various information
  633. # including table structures or if it's a
  634. # temporary table or not. The cache is
  635. # maintained in a pgpool child local memory
  636. # and being kept as long as it survives.
  637. # If someone modify the table by using
  638. # ALTER TABLE or some such, the relcache is
  639. # not consistent anymore.
  640. # For this purpose, cache_expiration
  641. # controls the life time of the cache.
  642.  
  643. relcache_size = 256
  644. # Number of relation cache
  645. # entry. If you see frequently:
  646. # "pool_search_relcache: cache replacement happend"
  647. # in the pgpool log, you might want to increate this number.
  648.  
  649. check_temp_table = on
  650. # If on, enable temporary table check in SELECT statements.
  651. # This initiates queries against system catalog of primary/master
  652. # thus increases load of master.
  653. # If you are absolutely sure that your system never uses temporary tables
  654. # and you want to save access to primary/master, you could turn this off.
  655. # Default is on.
  656.  
  657. check_unlogged_table = on
  658. # If on, enable unlogged table check in SELECT statements.
  659. # This initiates queries against system catalog of primary/master
  660. # thus increases load of master.
  661. # If you are absolutely sure that your system never uses unlogged tables
  662. # and you want to save access to primary/master, you could turn this off.
  663. # Default is on.
  664.  
  665. #------------------------------------------------------------------------------
  666. # IN MEMORY QUERY MEMORY CACHE
  667. #------------------------------------------------------------------------------
  668. memory_cache_enabled = off
  669. # If on, use the memory cache functionality, off by default
  670. memqcache_method = 'shmem'
  671. # Cache storage method. either 'shmem'(shared memory) or
  672. # 'memcached'. 'shmem' by default
  673. # (change requires restart)
  674. memqcache_memcached_host = 'localhost'
  675. # Memcached host name or IP address. Mandatory if
  676. # memqcache_method = 'memcached'.
  677. # Defaults to localhost.
  678. # (change requires restart)
  679. memqcache_memcached_port = 11211
  680. # Memcached port number. Mondatory if memqcache_method = 'memcached'.
  681. # Defaults to 11211.
  682. # (change requires restart)
  683. memqcache_total_size = 67108864
  684. # Total memory size in bytes for storing memory cache.
  685. # Mandatory if memqcache_method = 'shmem'.
  686. # Defaults to 64MB.
  687. # (change requires restart)
  688. memqcache_max_num_cache = 1000000
  689. # Total number of cache entries. Mandatory
  690. # if memqcache_method = 'shmem'.
  691. # Each cache entry consumes 48 bytes on shared memory.
  692. # Defaults to 1,000,000(45.8MB).
  693. # (change requires restart)
  694. memqcache_expire = 0
  695. # Memory cache entry life time specified in seconds.
  696. # 0 means infinite life time. 0 by default.
  697. # (change requires restart)
  698. memqcache_auto_cache_invalidation = on
  699. # If on, invalidation of query cache is triggered by corresponding
  700. # DDL/DML/DCL(and memqcache_expire). If off, it is only triggered
  701. # by memqcache_expire. on by default.
  702. # (change requires restart)
  703. memqcache_maxcache = 409600
  704. # Maximum SELECT result size in bytes.
  705. # Must be smaller than memqcache_cache_block_size. Defaults to 400KB.
  706. # (change requires restart)
  707. memqcache_cache_block_size = 1048576
  708. # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
  709. # Defaults to 1MB.
  710. # (change requires restart)
  711. memqcache_oiddir = '/var/log/pgpool/oiddir'
  712. # Temporary work directory to record table oids
  713. # (change requires restart)
  714. white_memqcache_table_list = ''
  715. # Comma separated list of table names to memcache
  716. # that don't write to database
  717. # Regexp are accepted
  718. black_memqcache_table_list = ''
  719. # Comma separated list of table names not to memcache
  720. # that don't write to database
  721. # Regexp are accepted
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!