PGPOOL_SHOW(1)

📦
version 4.7.2 · 7 versions
, in ubuntu stonking

💖 PGPOOL_SHOW — bestie, let's peek at ur config 💖

okay so this is pgpool_show(1) from the pgpool-II fam — it lives in the pgpool-II 4.7.2 Documentation and it's literally just "hey what's this setting set to rn" 🫶

✨ NAME ✨

PGPOOL_SHOW — shows u the value of a configuration parameter. that's it. that's the whole job. 💅

🌸 SYNOPSIS 🌸

PGPOOL SHOW configuration_parameter
PGPOOL SHOW configuration_parameter_group
PGPOOL SHOW ALL

🦋 DESCRIPTION 🦋

PGPOOL SHOW shows you the current value of Pgpool-II configuration parameters. no cap, that's it.

it's giving very much the same energy as the SHOW[1] command in PostgreSQL, except we slapped a PGPOOL keyword on the front so you can tell the two apart — because confusing them would be so not the move 😭

🎀 PARAMETERS 🎀

  • configuration_parameter — the name of a Pgpool-II configuration parameter, bestie. the available ones are documented in Chapter 5, Server Configuration, in the documentation. go read it, i'll wait 🫶
⚠️ Note — if the parameter has uppercase letters in it (like delegate_ip), you must wrap the parameter name in double quotes. no quotes, no vibe. it just won't work. 💀
  • configuration_parameter_group — the name of a Pgpool-II configuration parameter group. rn there are exactly four of them:
    • backend — the config group of all backend config parameters 👑
    • watchdog — the config group of all watchdog node config parameters 🐕
    • heartbeat — the configuration group of all watchdog heartbeat config parameters 💓
    • health_check — the configuration group of all health check parameters 🩺
  • ALL — shows the values of every single configuration parameter, with descriptions. the whole buffet. iconique. ✨

🔥 EXAMPLES 🔥

show the current setting of the parameter port

PGPOOL SHOW port;
port
------
9999
(1 row)

one row, zero drama. 💅

show the current setting of the parameter write_function_list

PGPOOL SHOW write_function_list;
write_function_list
---------------------
nextval,setval
(1 row)

look at that list go 😌

show the current settings of all the configuration parameters belonging to backend group

PGPOOL SHOW backend;
item                     |          value          |              description
-------------------------+-------------------------+-----------------------------------------------------------
backend_hostname0        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
backend_port0            | 5434                    | port number of PostgreSQL backend.
backend_weight0          | 0                       | load balance weight of backend.
backend_data_directory0  | /var/lib/pgsql/data     | data directory of the backend.
backend_flag0            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
backend_hostname1        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
backend_port1            | 5432                    | port number of PostgreSQL backend.
backend_weight1          | 1                       | load balance weight of backend.
backend_data_directory1  | /home/work/installed/pg | data directory of the backend.
backend_flag1            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
(10 rows)

ten rows of pure backend lore 🧚

show all settings

PGPOOL SHOW ALL;
item                     |          value          |              description
-------------------------+-------------------------+-----------------------------------------------------------
backend_hostname0        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
backend_port0            | 5434                    | port number of PostgreSQL backend.
backend_weight0          | 0                       | load balance weight of backend.
backend_data_directory0  | /var/lib/pgsql/data     | data directory of the backend.
backend_flag0            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
backend_hostname1        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
backend_port1            | 5432                    | port number of PostgreSQL backend.
backend_weight1          | 1                       | load balance weight of backend.
backend_data_directory1  | /home/work/installed/pg | data directory of the backend.
backend_flag1            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
hostname0                | localhost               | Hostname of pgpool node for watchdog connection.
.
.
.
ssl                      | off                     | Enables SSL support for frontend and backend connections
(138 rows)

okay so yeah, the . . . in the middle means it kept going and going and going — 138 rows of it, bestie. main character output fr fr. 💖

👑 SEE ALSO 👑

💜 NOTES 💜

  1. SHOW https://www.postgresql.org/docs/current/static/sql-show.html

<div style="text-align:center">🌸 🦋 🎀 ✨ 💅 ✨ 🎀 🦋 🌸</div>

and that's the whole page, bestie!! this was living its best life as pgpool-II 4.7.2, dated 2023, filed under PGPOOL SHOW(1). go forth and PGPOOL SHOW ALL — you got this, i believe in u 🫶💖

📦 where this page comes from