source url: https://www.heatware.net/databases/postgresql-reload-config-without-restarting/
If you are making modifications to the Postgres configuration file postgresql.conf (or similar), and you want to new settings to take effect without needing to restart the entire database, there are two ways to accomplish this.
Option 1: From the command-line shell
su - postgres
/usr/bin/pg_ctl reload
Option 2: Using SQL
SELECT pg_reload_conf();
Using either option will not interrupt any active queries or connections to the database, thus applying these changes seemlessly.
网友评论