NetBSD Problem Report #58773

From www@netbsd.org  Wed Oct 23 23:57:13 2024
Return-Path: <www@netbsd.org>
Received: from mail.netbsd.org (mail.netbsd.org [199.233.217.200])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256
	 client-signature RSA-PSS (2048 bits) client-digest SHA256)
	(Client CN "mail.NetBSD.org", Issuer "mail.NetBSD.org CA" (not verified))
	by mollari.NetBSD.org (Postfix) with ESMTPS id 3AB471A9238
	for <gnats-bugs@gnats.NetBSD.org>; Wed, 23 Oct 2024 23:57:13 +0000 (UTC)
Message-Id: <20241023235712.1CD431A923D@mollari.NetBSD.org>
Date: Wed, 23 Oct 2024 23:57:12 +0000 (UTC)
From: charleshaincque@gmail.com
Reply-To: charleshaincque@gmail.com
To: gnats-bugs@NetBSD.org
Subject: Warnings during PostgreSQL Server startup
X-Send-Pr-Version: www-1.0

>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:/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.

Home	PR Database Search