pt-config¶

Summary¶

Refer the setting of the PosgreSQL configuration file postgresql.conf, and then modify it.

Usage¶

pt-config [options...] get [PARAM]
pt-config [options...] set [PARAM] [VALUE]
pt-config [options...] disable [PARAM]

Commands¶

`get [PARAM]`	Displays the current value. If it is disabled(comment-out). `(disabled)` is displayed.
`set [PARAM] [VALUE]`	Sets the new value. The value will be enabled if it is disabled (comment-out).
`disable [PARAM]`	Disable the setting value.(comment-out)

Options¶

-D, --pgdata=PGDATA        Specify a PostgreSQL database cluster.
--apply                    Apply change(s).
--help                     Print this help.

-D, --pgdata Specifies the PostgreSQL database cluster. If not specified, to set the value of PGDATA.

--apply It will actually apply the changes to the postgresql.conf when it runs set / disable command.

Output Items¶

`Reading:`	Loading the `postgresql.conf` file displays in the full path.
`Dry-run mode:`	The before and after values is only displayed. It does not provide the actual configuration changes.
`Applying:`	Doing the actual configuration changes.
`Old`	Displays the value of before change.
`New`	Displays the value of after change.
`Updating:`	Modifying the `postgresql.conf` file displays in the full path.

Examples¶

Displays the current value of shared_buffers

$ pt-config -D /var/lib/pgsql/9.4/data get shared_buffers
[2015-04-16 17:08:12] INFO: Reading: /var/lib/pgsql/9.4/data/postgresql.conf
256MB
$

Sets the value 512MB of shared_buffers. (Does not do the actual configuration changes)

$ pt-config -D /var/lib/pgsql/9.4/data set shared_buffers 512MB
[2015-04-16 17:08:44] INFO: Reading: /var/lib/pgsql/9.4/data/postgresql.conf
[2015-04-16 17:08:44] INFO: Dry-run mode:
[2015-04-16 17:08:44] INFO:   Old: shared_buffers = 256MB                       # min 128kB
[2015-04-16 17:08:44] INFO:   New: shared_buffers = 512MB                       # min 128kB
$

Sets the value 512MB of shared_buffers. (Doing the actual configuration change)

$ pt-config -D /var/lib/pgsql/9.4/data --apply set shared_buffers 512MB
[2015-04-16 17:09:11] INFO: Reading: /var/lib/pgsql/9.4/data/postgresql.conf
[2015-04-16 17:09:11] INFO: Applying:
[2015-04-16 17:09:11] INFO:   Old: shared_buffers = 256MB                       # min 128kB
[2015-04-16 17:09:11] INFO:   New: shared_buffers = 512MB                       # min 128kB
[2015-04-16 17:09:11] INFO: Updated: /var/lib/pgsql/9.4/data/postgresql.conf
$

Sets the disable(comment-out) of shared_buffers.

$ pt-config -D /var/lib/pgsql/9.4/data --apply disable shared_buffers
[2015-04-16 17:09:52] INFO: Reading: /var/lib/pgsql/9.4/data/postgresql.conf
[2015-04-16 17:09:52] INFO: Applying:
[2015-04-16 17:09:52] INFO:   Old: shared_buffers = 512MB                       # min 128kB
[2015-04-16 17:09:52] INFO:   New: #shared_buffers = 512MB                      # min 128kB
[2015-04-16 17:09:52] INFO: Updated: /var/lib/pgsql/9.4/data/postgresql.conf
$

Displays the value of shared_buffers (Disabled).

$ pt-config -D /var/lib/pgsql/9.4/data get shared_buffers
[2015-04-16 17:10:00] INFO: Reading: /var/lib/pgsql/9.4/data/postgresql.conf
512MB (disabled)
$