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()
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With