ログイン
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