Обсуждение: Which parameters requires a restart?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, In postgresql.conf, we have such a sentence: "Some settings, such as listen_address, require a postmaster shutdown and restart to take effect." Which other parameter changes requires a restart? Do we have a doc on this? Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCGPkitl86P3SPfQ4RAhN7AJ9nBXSQioV/RpruLv+bDIXCrniA7wCggRPL kikRV8iUNrp0/Ou6q0+gP6s= =zX1Q -----END PGP SIGNATURE-----
Hi myself, On Sun, 20 Feb 2005, Devrim GUNDUZ wrote: > In postgresql.conf, we have such a sentence: > > "Some settings, such as listen_address, require a postmaster shutdown and > restart to take effect." > > Which other parameter changes requires a restart? Do we have a doc on > this? I think I've found it: http://www.powerpostgresql.com/Downloads/annotated_conf_80.html Regards, -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org
Devrim GUNDUZ <devrim@gunduz.org> writes: > In postgresql.conf, we have such a sentence: > "Some settings, such as listen_address, require a postmaster shutdown and > restart to take effect." > Which other parameter changes requires a restart? Do we have a doc on > this? http://www.postgresql.org/docs/8.0/static/runtime-config.html says "this parameter can only be set at server start" in the appropriate places. regards, tom lane