apiVersion

fep.fujitsu.io/v1

Fixed

kind

FEPPgpool2

Fixed

metadata.name

-

List the name of the FEP Pgpool2 container.

metadata.namespace

-

Specify the namespace of the environment where you want to deploy the operator.

spec.fepVersion

Optional

To use FEPPgpool2 image of given version. Possible values: 14, 15, 16, 17 & 18

spec.image

<current-released-image>

FEPPgpool2 container image to be used

quay.io/fujitsu/fujitsu-enterprise-postgres-18-pgpool2:ubi9-18-1.0

It is optional.

Image is left blank by default. In such a case, it will pick up URL of image from operator container environment.

If you specify the image, Operator will take that image to deploy container.

spec.count

2

List the number of FEP Pgpool2 containers to create.

spec.serviceport

9999

Describes the TCP port for connecting to the FEP Pgpool2 container.

spec.statusport

9898

Identifies the TCP port for connecting to the PCP process.

spec.limits.cpu

400m

List the number of CPUs (restriction) to allocate to resources.limits.cpu.

spec.limits.memory

512Mi

Specifies the memory size (restriction) to allocate to resources.limits.memory.

spec.requests.cpu

200m

List the number of CPUs (request) to allocate to resources.requests.cpu.

spec.requests.memory

256Mi

Specifies the memory size (request) to allocate to resources.requests.memory

spec.fepclustername

new-fep

Enter the FEPCluster name to connect to.

spec.customhba

If you want to use pool _ hba.conf, describe what pool _ hba.conf should contain from the line below.

spec.customparams

listen_addresses = '*'

pcp_listen_addresses = '*'

num_init_children = 32

reserved_connections = 0

enable_pool_hba = off

allow_clear_text_frontend_auth = off

authentication_timeout = 80

backend_weight0 = 1

backend_weight1 = 1

backend_flag0 = 'ALWAYS_PRIMARY'

backend_flag1 = 'DISALLOW_TO_FAILOVER'

connection_cache = on

max_pool = 4

listen_backlog_multiplier = 2

serialize_accept = off

child_life_time = 300

client_idle_limit = 0

child_max_connections = 0

connection_life_time = 0

reset_query_list = 'ABORT; DISCARD ALL'

client_min_messages = info

log_min_messages = debug1

log_statement = on

log_per_node_statement = on

log_client_messages = on

log_hostname = on

log_connections = on

log_line_prefix = '%t: pid %p: '

load_balance_mode = on

ignore_leading_white_space = on

white_function_list = ''

black_function_list = 'currval,lastval,nextval,setval'

black_query_pattern_list = ''

database_redirect_preference_list = ''

app_name_redirect_preference_list = ''

allow_sql_comments = off

disable_load_balance_on_write = 'transaction'

statement_level_load_balance = on

sr_check_period = 0

sr_check_user = 'postgres'

delay_threshold = 0

log_standby_delay = 'none'

ssl = on

ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL'

ssl_prefer_server_ciphers = off

ssl_ecdh_curve = 'prime256v1'

ssl_dh_params_file = ''

relcache_expire = 0

relcache_size = 256

check_temp_table = catalog

check_unlogged_table = on

enable_shared_relcache = off

relcache_query_target = primary

wd_port0 = 9000

failover_on_backend_error = off

"|" and the Pgpool-II parameters. Refer to "Pgpool-II parameters" for detail.

spec.custompcp

"|"

If you use the pcp command, "|" and the contents of pcp.conf from the line below.

spec.customsslkey

"|"

If you want to do it, "|" and the Beethoven key content in the line below.

spec.customsslcert

"|"

If you want to do it, "|" and the contents of the public x 509 certificate from the line below.

spec.customsslcacert

"|"

If you want to do it, "|" and the following lines describe the contents of the CA root certificate in PEM format.

spec.customlogsize

100 Mi

Specifies the persistent volume size for log output.

spec.storageclassname

Specifies the storage class for log output.

NFS storage is not available if you enable the following parameters:

• enable_shared_relcache

• memory_cache_enabled

spec.clientAuthMethod

Optional

Specifies the method for client authentication.

Define "scram" to use scram-sha-256 authentication. Otherwise, the client authentication method is still md5.

spec.scram.pgpoolkeySecret

Optional

Describes the name of the secret that stores the key for use in encryption/decryption.

Can only be specified at creation time.

If you change the contents of the specified secret, a restart is required.

spec.scram.userinfoSecret

Optional

Write the name of the secret that contains the user name you added and the password that corresponds to that user.

Can only be specified at creation time.

Connection settings

listen_addresses (string)

Y

pcp_listen_addresses (string)

Y

num_init_children (integer)

Y

reserved_connections (integer)

Y

Authentication settings

enable_pool_hba (boolean)

allow_clear_text_frontend_auth (boolean)

authentication_timeout (integer)

Backend settings

backend_weight0 (floating point)

backend_weight1 (floating point)

backend_flag0

backend_flag1

Connection pooling

connection_cache (boolean)

Y

max_pool (integer)

Y

listen_backlog_multiplier (integer)

Y

serialize_accept (boolean)

Y

child_life_time (integer)

Y

client_idle_limit (integer)

child_max_connections (integer)

Y

connection_life_time (integer)

Y

reset_query_list (string)

Error reporting and log acquisition

client_min_messages (enum)

log_min_messages (enum)

log_statement (boolean)

log_per_node_statement (boolean)

log_client_messages (boolean)

log_hostname (boolean)

log_connections (boolean)

log_error_verbosity (enum)

log_line_prefix (string)

Load sharing settings

load_balance_mode (boolean)

Y

ignore_leading_white_space (boolean)

white_function_list (string)

black_function_list (string)

black_query_pattern_list (string)

database_redirect_preference_list (string)

app_name_redirect_preference_list (string)

allow_sql_comments (boolean)

disable_load_balance_on_write (string)

Y

statement_level_load_balance (boolean)

Health check

connect_timeout (integer)

Streaming replication check

sr_check_period (integer)

sr_check_user (string)

sr_check_password (string)

sr_check_database (string)

delay_threshold (integer)

log_standby_delay (string)

Secure Sockect Layer (SSL)

ssl (boolean)

Y

ssl_ciphers (string)

Y

ssl_prefer_server_ciphers (boolean)

Y

ssl_ecdh_curve (string)

Y

ssl_dh_params_file (string)

Y

Other parameters

relcache_expire (integer)

Y

relcache_size (integer)

Y

enable_shared_relcache (boolean)

Y

relcache_query_target (enum)

check_temp_table (enum)

check_unlogged_table (boolean)