Bug 267500 - databases/postgresql*-server: require mountlate in rc.d scripts
Summary: databases/postgresql*-server: require mountlate in rc.d scripts
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Dmitry Marakasov
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-11-01 17:46 UTC by Dmitry Marakasov
Modified: 2022-11-15 15:42 UTC (History)
0 users

See Also:

Attachments
Patch (2.99 KB, patch)
2022-11-01 17:46 UTC, Dmitry Marakasov 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dmitry Marakasov freebsd_committer freebsd_triage 2022-11-01 17:46:17 UTC 
Created attachment 237789 [details]
Patch

Depend on mountlate, as some filesystems used by postgresql server may be mounted late.

My case: /tmp is late-mounted tmpfs atop of ZFS, and without this patch postgres starts before the filesystem is mounted and its socket is lost.
Comment 1 commit-hook freebsd_committer freebsd_triage 2022-11-15 15:42:29 UTC 
A commit in branch main references this bug:

URL: https://cgit.FreeBSD.org/ports/commit/?id=d512e8cce2abc9375784bc1dc4c91d5353e867a0

commit d512e8cce2abc9375784bc1dc4c91d5353e867a0
Author:     Dmitry Marakasov <amdmi3@FreeBSD.org>
AuthorDate: 2022-05-17 10:49:50 +0000
Commit:     Dmitry Marakasov <amdmi3@FreeBSD.org>
CommitDate: 2022-11-15 15:40:59 +0000

    databases/postgresql*-server: require mountlate in rc.d scripts

    PostgreSQL server may use late-mounted filesystems, so require these
    in rc.d scripts. Real life example is when /tmp is late-mounted tmpfs
    atop of ZFS, and if posgresql-server starts before mountlate, its
    socket which resides on /tmp is hidden under tmpfs which is mounted
    afterwards.

    PR:             267500
    Approved by:    maintainer timeout (pgsql, 2 weeks)

 databases/postgresql10-server/Makefile            | 2 +-
 databases/postgresql10-server/files/postgresql.in | 2 +-
 databases/postgresql11-server/Makefile            | 2 +-
 databases/postgresql11-server/files/postgresql.in | 2 +-
 databases/postgresql12-server/Makefile            | 2 +-
 databases/postgresql12-server/files/postgresql.in | 2 +-
 databases/postgresql13-server/Makefile            | 2 +-
 databases/postgresql13-server/files/postgresql.in | 2 +-
 databases/postgresql14-server/Makefile            | 2 +-
 databases/postgresql14-server/files/postgresql.in | 2 +-
 databases/postgresql15-server/Makefile            | 2 +-
 databases/postgresql15-server/files/postgresql.in | 2 +-
 12 files changed, 12 insertions(+), 12 deletions(-)