pkg/58773: Warnings during PostgreSQL Server startup

[charleshaincque%gmail.com@localhost]

>Number:         58773
>Category:       pkg
>Synopsis:       Warnings during PostgreSQL Server startup
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    pkg-manager
>State:          open
>Class:          doc-bug
>Submitter-Id:   net
>Arrival-Date:   Thu Oct 24 00:00:00 +0000 2024
>Originator:     Charles Haincque
>Release:        pkgsrc-2024Q3
>Organization:
>Environment:
NetBSD lotus.vm.tornadovps.net 9.3 NetBSD 9.3 (XEN3_DOMU) #0: Thu Aug  4 15:30:37 UTC 2022 mkrepro%mkrepro.NetBSD.org@localhost:/usr/src/sys/arch/xen/compile/XEN3_DOMU amd64
>Description:
While following the instructions provided on the wiki page:
https://wiki.netbsd.org/pkgsrc/how_to_install_a_postgresql_server/

I encountered warnings during the initialization and startup of the PostgreSQL server.

Here is the output from the specified commands:

# /etc/rc.d/pgsql initdb -E unicode
/etc/rc.d/pgsql: WARNING: $pgsql is not set properly - see rc.conf(5).
$pgsql is not enabled - see rc.conf(5).
Use the following if you wish to perform the operation:
/etc/rc.d/pgsql oneinitdb

# /etc/rc.d/pgsql start
/etc/rc.d/pgsql: WARNING: $pgsql is not set properly - see rc.conf(5).
$pgsql is not enabled - see rc.conf(5).
Use the following if you wish to perform the operation:
/etc/rc.d/pgsql onestart
>How-To-Repeat:
Follow the instructions on the wiki page.
>Fix:
Setting the pgsql variable in rc.conf to either YES or NO resolves the warning message. If the pgsql value is set to NO, use the oneinitdb, onestart, and onestop commands to manage the server.