11

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?

majackson
  • 2,823
  • 6
  • 22
  • 38
  • 3
    in `psql` run `select pg_reload_conf();` but make sure parameter you are configuring does not require actual restart – Dmitry S Sep 09 '15 at 03:14
  • There is now a pretty good documentation site (in 2023) that will show you which changes can be applied when. https://postgresqlco.nf/doc/en/param/max_standby_streaming_delay/ – boatcoder Sep 01 '23 at 13:08

1 Answers1

27

Simplest way: SELECT pg_reload_conf();

boatcoder
  • 17,525
  • 18
  • 114
  • 178
Craig Ringer
  • 307,061
  • 76
  • 688
  • 778