With a regular postgres install, I would do this either by sending SIGHUP to the postgres process, or by running pg_ctl reload
. With Postgres.app, however, I'm unsure about where to send SIGHUP (to the Postgres.app process, or one of the workers?), and attempting to run pg_ctl reload
(after tracking it down to /Applications/Postgres.app/Contents/Versions/9.3/bin
yields only complaints about PG_DATA being unset.
So, how do I reload the configuration files for Postgres.app without restarting the whole server? Is this possible?
Simplest way:
SELECT pg_reload_conf();