pg_ctl only allows 12 parameters?
От
Ron Johnson
Тема
pg_ctl only allows 12 parameters?
Дата
Msg-id
CANzqJaDCagH5wNkPQ42=Fx3mJPR-YnB3PWFdCAYAVdb9=Q+t-A@mail.gmail.com
Список
Дерево обсуждения
pg_ctl only allows 12 parameters? Ron Johnson <ronljohnsonjr@gmail.com>
Re: pg_ctl only allows 12 parameters? "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_ctl only allows 12 parameters? Ron Johnson <ronljohnsonjr@gmail.com>
Re: pg_ctl only allows 12 parameters? "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_ctl only allows 12 parameters? Ron Johnson <ronljohnsonjr@gmail.com>
Re: pg_ctl only allows 12 parameters? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_ctl only allows 12 parameters? Ron Johnson <ronljohnsonjr@gmail.com>
Re: pg_ctl only allows 12 parameters? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_ctl only allows 12 parameters? Ron Johnson <ronljohnsonjr@gmail.com>
Re: pg_ctl only allows 12 parameters? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_ctl only allows 12 parameters? "David G. Johnston" <david.g.johnston@gmail.com>
PG 14.10
pg_ctl failed when I added a thirteenth parameter (log_temp_files). Is this documented, and I missed it?
(The purpose is to optimize for a 30-thread pg_restore of a multi-TB 9.6 database. Once it's finished, I stop/start, to enable "production" values like fsync=on.)
pg_ctl restart -wt999 -mfast
-o '-c fsync=off' \
-o '-c full_page_writes=off' \
-o '-c log_statement=none' \
-o '-c log_temp_files=100kB' \
-o '-c max_wal_size=36GB' \
-o '-c wal_level=minimal' \
-o '-c max_wal_senders=0' \
-o '-c wal_buffers=64MB' \
-o '-c log_checkpoints=off' \
-o '-c autovacuum=off'
pg_ctl: too many command-line arguments (first is "restart")
-o '-c fsync=off' \
-o '-c full_page_writes=off' \
-o '-c log_statement=none' \
-o '-c log_temp_files=100kB' \
-o '-c max_wal_size=36GB' \
-o '-c wal_level=minimal' \
-o '-c max_wal_senders=0' \
-o '-c wal_buffers=64MB' \
-o '-c log_checkpoints=off' \
-o '-c autovacuum=off'
pg_ctl: too many command-line arguments (first is "restart")
В списке pgsql-admin по дате отправления
От: Stephen Frost
Дата: