pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Default to dynamic_shared_memory_type=sysv on Solaris. 2+ messages / 1 participants [nested] [flat]
* pgsql: Default to dynamic_shared_memory_type=sysv on Solaris. @ 2022-07-02 04:26 Thomas Munro <tmunro@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Thomas Munro @ 2022-07-02 04:26 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Default to dynamic_shared_memory_type=sysv on Solaris. POSIX shm_open() can sleep for a long time and fail spuriously because of contention on an internal lock file on Solaris (and presumably illumos). Commit 389869af fixed the main problem with this, namely that we could crash, but it's now clear that "posix" is not a good default. Therefore, choose "sysv" at initdb time on Solaris and illumos. Other choices are still available by editing the postgresql.conf file. Back-patch only to 15, because contention is much less likely further back, and it doesn't seem like a good idea to change this in released branches. This should clear up the failures on build farm animal margay. Discussion: https://postgr.es/m/CA%2BhUKGKqKrCV5xKWfh9rnm%3Do%3DDwZLTLtnsj_XpUi9g5%3DV%2B9oyg%40mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/94ebf8117c93f19218e60eb24f3f6bd09b796767 Modified Files -------------- doc/src/sgml/config.sgml | 2 +- src/backend/utils/misc/postgresql.conf.sample | 2 +- src/bin/initdb/initdb.c | 5 ++++- 3 files changed, 6 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Default to dynamic_shared_memory_type=sysv on Solaris. @ 2022-07-02 04:26 Thomas Munro <tmunro@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Thomas Munro @ 2022-07-02 04:26 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Default to dynamic_shared_memory_type=sysv on Solaris. POSIX shm_open() can sleep for a long time and fail spuriously because of contention on an internal lock file on Solaris (and presumably illumos). Commit 389869af fixed the main problem with this, namely that we could crash, but it's now clear that "posix" is not a good default. Therefore, choose "sysv" at initdb time on Solaris and illumos. Other choices are still available by editing the postgresql.conf file. Back-patch only to 15, because contention is much less likely further back, and it doesn't seem like a good idea to change this in released branches. This should clear up the failures on build farm animal margay. Discussion: https://postgr.es/m/CA%2BhUKGKqKrCV5xKWfh9rnm%3Do%3DDwZLTLtnsj_XpUi9g5%3DV%2B9oyg%40mail.gmail.com Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/a2b0719cc22d6f7fffa316b5da0fb5b22526c63e Modified Files -------------- doc/src/sgml/config.sgml | 2 +- src/backend/utils/misc/postgresql.conf.sample | 2 +- src/bin/initdb/initdb.c | 5 ++++- 3 files changed, 6 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-07-02 04:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-07-02 04:26 pgsql: Default to dynamic_shared_memory_type=sysv on Solaris. Thomas Munro <tmunro@postgresql.org> 2022-07-02 04:26 pgsql: Default to dynamic_shared_memory_type=sysv on Solaris. Thomas Munro <tmunro@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox