Обсуждение: 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