| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
| Cc: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>, Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Remotely reload server config? |
| Date: | 2005-11-03 16:52:54 |
| Message-ID: | 200511031652.jA3Gqsg18638@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SCassidy | 2005-11-03 17:02:09 | Re: Changing ids conflicting with serial values? |
| Previous Message | brew | 2005-11-03 16:44:56 | Re: question about Postgresql and rsync |