| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | rod(at)iol(dot)ie, John R Pierce <pierce(at)hogranch(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Remote Connection |
| Date: | 2009-02-14 03:40:30 |
| Message-ID: | dcc563d10902131940w3df8ed6bv418a6582e905a39a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 13, 2009 at 3:43 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
> In pg_hba there is a reference to reloading postmaster using pg_ctl.
>
> Does postmaster reload when the server is restarted??
Yep. restart shuts down pgsql, and then starts it up fresh, so it has
to read its config files etc. Reload is useful because it doesn't
shut down a server, which can be handy on 24/7 machines that need
config changes.
As noted by others, some changes require a restart, basically the
things the server can't change while it's running, like share_buffers,
which are allocated at start up.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2009-02-14 08:44:14 | Re: temporary table problem |
| Previous Message | Sam Mason | 2009-02-14 02:55:32 | Re: can't figure string compare result (using also custom C function) |