X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C8B7AD1B4BC for ; Fri, 19 Mar 2004 17:54:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 98201-05 for ; Fri, 19 Mar 2004 13:54:18 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 7E210D1E9B8 for ; Fri, 19 Mar 2004 13:54:17 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i2JHsG1Y059451 for ; Fri, 19 Mar 2004 17:54:16 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i2JHg27Z056927 for pgsql-admin@postgresql.org; Fri, 19 Mar 2004 17:42:02 GMT From: litaowu@yahoo.com (Litao Wu) X-Newsgroups: comp.databases.postgresql.admin Subject: postgresql.conf and pg_ctl reload Date: 19 Mar 2004 09:41:59 -0800 Organization: http://groups.google.com Lines: 23 Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/275 X-Sequence-Number: 12844 Hi all, postgresql.conf says: # This file is read on postmaster startup and when the postmaster # receives a SIGHUP. If you edit the file on a running system, you have # to SIGHUP the postmaster for the changes to take effect, or use # "pg_ctl reload". Does that mean I can just use "pg_ctl reload" to let the changed parameters take affect? Or do I have to restart postgres? Or only some parameters can be taken affect by "pg_ctl reload" (if this case, what are they)? Same question from man page of pg_ctl: pg_ctl reload - simply sends the postmaster a SIGHUP signal, causing it to reread its configuration files (postgresql.conf, pg_hba.conf, etc.). This allows changing of configuration-file options that do not require a complete restart to take effect. The problem is which options do not require a complete restart and which ones do? Thanks,