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
Option 2: Using SQL
Using either option will not interrupt any active queries or connections to the database, thus applying these changes seemlessly.