База знаний » БД PostgreSQL

h1. Изменеие параметров postgresql 9.4+ в runtime

h2. На примере включения опций логгирования

h3. Включить:

<pre>

postgres=# ALTER SYSTEM SET log_duration = on;

ALTER SYSTEM

postgres=# ALTER SYSTEM SET log_connections = on;

ALTER SYSTEM

postgres=# ALTER SYSTEM SET log_disconnections = on;

ALTER SYSTEM

postgres=# ALTER SYSTEM SET log_statement = 'all';

ALTER SYSTEM

postgres=# ALTER SYSTEM SET log_temp_files = 0;

ALTER SYSTEM

postgres=# SELECT pg_reload_conf();

</pre>

h2. Отключить:

<pre>

postgres=# ALTER SYSTEM RESET log_duration;

ALTER SYSTEM

postgres=# ALTER SYSTEM RESET log_connections;

ALTER SYSTEM

postgres=# ALTER SYSTEM RESET log_disconnections;

ALTER SYSTEM

postgres=# ALTER SYSTEM RESET log_statement;

ALTER SYSTEM

postgres=# ALTER SYSTEM RESET log_temp_files;

ALTER SYSTEM

postgres=# SELECT pg_reload_conf();

</pre>

h2. Изменения сохраняются в postgresql.auto.conf

<pre>

# Do not edit this file manually!

# It will be overwritten by ALTER SYSTEM command.

log_duration = 'on'

log_connections = 'on'

log_disconnections = 'on'

log_statement = 'all'

log_temp_files = '0'

</pre>