Florian G. Pflug wrote: > Tony Caduto wrote: > > Does anyone know if there is a way to reload the server config remotely > > via a sql command? > > > > I looked through the docs, but may have missed it. > AFAIK thats not possible with postgresql out-of-the-box. > > The latest pgadminIII release (1.4), however, includes some > server-side funktions that allow remotely editing the config > file, and also allow restarting the server i believe. > > You'd have to install those funktions into some database > on your server. PostgreSQL 8.1 RC1 has pg_reload_conf() which does what you want. -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
