t1 has one error,why?

[msdnchina]

my postgres version is 12.1:

Type your choice and press :
t1
psql:/home/pg121/postgres_dba/sql/t1_tuning.sql:7: error: unrecognized value ":postgres_dba_interactive_mode" for "\if expression": Boolean expected
Parameter | Value | Default | Category
---------------------------------+---------+---------+------------------------------------------------------
autovacuum_analyze_scale_factor | 0.1 | 0.1 | Autovacuum
autovacuum_max_workers | 3 | 3 | Autovacuum
autovacuum_naptime | 60 | 60 | Autovacuum
autovacuum_vacuum_scale_factor | 0.2 | 0.2 | Autovacuum
max_connections | 100 | 100 | Connections and Authentication / Connection Settings
default_statistics_target | 100 | 100 | Query Tuning / Other Planner Options
effective_cache_size | 4096 MB | 4096 MB | Query Tuning / Planner Cost Constants
random_page_cost | 4 | 4 | Query Tuning / Planner Cost Constants
seq_page_cost | 1 | 1 | Query Tuning / Planner Cost Constants
effective_io_concurrency | 1 | 1 | Resource Usage / Asynchronous Behavior
max_parallel_workers | 8 | 8 | Resource Usage / Asynchronous Behavior
max_parallel_workers_per_gather | 2 | 2 | Resource Usage / Asynchronous Behavior
max_worker_processes | 8 | 8 | Resource Usage / Asynchronous Behavior
autovacuum_work_mem | -1 | -1 | Resource Usage / Memory
maintenance_work_mem | 64 MB | 64 MB | Resource Usage / Memory
shared_buffers | 128 MB | 8192 kB | Resource Usage / Memory
work_mem | 4096 kB | 4096 kB | Resource Usage / Memory
checkpoint_completion_target | 0.5 | 0.5 | Write-Ahead Log / Checkpoints
max_wal_size | 1024 | 1024 | Write-Ahead Log / Checkpoints
min_wal_size | 80 | 80 | Write-Ahead Log / Checkpoints
wal_buffers | 4096 kB | -1 | Write-Ahead Log / Settings
(21 rows)

Press to continue…

[NikolayS]

Uh, it was my attempt to have both good CI tests (running in a non-interactive mode) and the main, interactive mode for humans.

An unfinished attempt – t1 doesn't offer any recommendations, the work is unfinished. It only shows the main performance configuration params, and then you can use something like https://pgtune.leopard.in.ua/ to perform tuning (very, very basic, of course).

I'm thinking about what to do with it, thanks for the bug report @msdnchina! Somehow this error is not easy to notice.

To get rid of it right now, please add this to ~/.psqlrc:

\set postgres_dba_interactive_mode false