ログイン

cmd

C:\Users\xxx>psql -U postgres`
ユーザ postgres のパスワード:

パラメータの確認

pgsql

postgres=# show all;
                  name                  |                       setting                       |                                                          description
----------------------------------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------
 allow_system_table_mods                | off                                                 | Allows modifications of the structure of system tables.
 application_name                       | psql                                                | Sets the application name to be reported in statistics and logs.
 archive_command                        | (disabled)                                          | Sets the shell command that will be called to archive a WAL file.
 archive_mode                           | off                                                 | Allows archiving of WAL files using archive_command.
 archive_timeout                        | 0                                                   | Forces a switch to the next WAL file if a new file has not been started within N seconds.

pgsql

postgres=# select name, setting, unit from pg_settings;
                  name                  |                       setting                       | unit
----------------------------------------+-----------------------------------------------------+------
 allow_system_table_mods                | off                                                 |
 application_name                       | psql                                                |
 archive_command                        | (disabled)                                          |
 archive_mode                           | off                                                 |
 archive_timeout                        | 0                                                   | s