Which parameters requires a restart?

Started by Devrim GÜNDÜZabout 21 years ago3 messagesgeneral
Jump to latest
#1Devrim GÜNDÜZ
devrim@gunduz.org

-----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-----

#2Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: Devrim GÜNDÜZ (#1)
Re: Which parameters requires a restart?

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

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Devrim GÜNDÜZ (#1)
Re: Which parameters requires a restart?

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