From patchwork Thu Nov 21 10:15:52 2019 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Pascal de Bruijn X-Patchwork-Id: 1198866 Return-Path: X-Original-To: incoming-buildroot@patchwork.ozlabs.org Delivered-To: patchwork-incoming-buildroot@bilbo.ozlabs.org Authentication-Results: ozlabs.org; spf=pass (sender SPF authorized) smtp.mailfrom=busybox.net (client-ip=140.211.166.133; helo=hemlock.osuosl.org; envelope-from=buildroot-bounces@busybox.net; receiver=) Authentication-Results: ozlabs.org; dmarc=none (p=none dis=none) header.from=unilogic.nl Authentication-Results: ozlabs.org; dkim=fail reason="signature verification failed" (2048-bit key; unprotected) header.d=unilogic.nl header.i=@unilogic.nl header.b="CWsiGgVp"; dkim-atps=neutral Received: from hemlock.osuosl.org (smtp2.osuosl.org [140.211.166.133]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ozlabs.org (Postfix) with ESMTPS id 47Jb7F54WPz9sPj for ; Thu, 21 Nov 2019 21:16:09 +1100 (AEDT) Received: from localhost (localhost [127.0.0.1]) by hemlock.osuosl.org (Postfix) with ESMTP id B1074887EF; Thu, 21 Nov 2019 10:16:04 +0000 (UTC) X-Virus-Scanned: amavisd-new at osuosl.org Received: from hemlock.osuosl.org ([127.0.0.1]) by localhost (.osuosl.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id wpzLrsYBCK7M; Thu, 21 Nov 2019 10:15:59 +0000 (UTC) Received: from ash.osuosl.org (ash.osuosl.org [140.211.166.34]) by hemlock.osuosl.org (Postfix) with ESMTP id 9533C887DC; Thu, 21 Nov 2019 10:15:59 +0000 (UTC) X-Original-To: buildroot@lists.busybox.net Delivered-To: buildroot@osuosl.org Received: from whitealder.osuosl.org (smtp1.osuosl.org [140.211.166.138]) by ash.osuosl.org (Postfix) with ESMTP id 712D21BF372 for ; Thu, 21 Nov 2019 10:15:58 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by whitealder.osuosl.org (Postfix) with ESMTP id 6C15187EBC for ; Thu, 21 Nov 2019 10:15:58 +0000 (UTC) X-Virus-Scanned: amavisd-new at osuosl.org Received: from whitealder.osuosl.org ([127.0.0.1]) by localhost (.osuosl.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VNWYkAggHSzy for ; Thu, 21 Nov 2019 10:15:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-out123.unilogicnetworks.net (mail-out123.unilogicnetworks.net [62.133.206.123]) by whitealder.osuosl.org (Postfix) with ESMTPS id BF36A87EB8 for ; Thu, 21 Nov 2019 10:15:57 +0000 (UTC) Received: from mail.unilogic.nl (unknown [62.133.204.111]) by mail.unilogicnetworks.net (Postfix) with ESMTPS id 885594A2E3; Thu, 21 Nov 2019 11:15:56 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=unilogic.nl; s=mail; h=from:subject:date:message-id:to:cc; bh=MLKUR3l2vVIEyrba/ZthYR5mBDbNRVdcw0LR/QvE95E=; b=CWsiGgVpBm9+Y+pv7UzIo0W9vAtE4ATe5gYokWFyWcbFO0oppPaNGvtav2EZGQMwycyT2Eh+Kap4W 6QT7vT58QWB1B8MxVhEiALUisDe2xCeVToVgk0JecY62O/2lsGSFGuLHfRvBwGwyRwME6zlgshpxkl cDHEj2PCi9HfYSX7A4FBRKiG1CjB3bqTdswvb7A1kQjgLhQXFRt52/hIlsWAgdhaKQ7fkwV9H33mDk DGrXHiBDiITrfqibzyULv2xSPwaN76nlZDlPVa4rcKzmUSXPVDI74NYerBjty+YJkNGPw6m0wPZl1J E52r6EH+vX+M65aoLdUEYfmBy9JeB/A== X-Kerio-Anti-Spam: Build: [Engines: 2.15.9.1281, Stamp: 3], Multi: [Enabled, t: (0.000006, 0.003299)], BW: [Enabled, t: (0.000007)], RTDA: [Enabled, t: (0.044729), Hit: No, Details: v2.7.64; Id: 15.1i61gen.1dq6nc515.6jg5l], total: 0(700) X-Footer: dW5pbG9naWMubmw= Received: from localhost ([127.0.0.1]) by mail.unilogic.nl with ESMTPSA (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256 bits)); Thu, 21 Nov 2019 11:15:56 +0100 From: Pascal de Bruijn To: buildroot@busybox.net Date: Thu, 21 Nov 2019 11:15:52 +0100 Message-Id: <20191121101552.6845-1-p.debruijn@unilogic.nl> X-Mailer: git-send-email 2.17.1 Subject: [Buildroot] [PATCH 2/2] package/postgresql: enable data checksums by default for initdb X-BeenThere: buildroot@busybox.net X-Mailman-Version: 2.1.29 Precedence: list List-Id: Discussion and development of buildroot List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: Pascal de Bruijn , Pascal de Bruijn MIME-Version: 1.0 Errors-To: buildroot-bounces@busybox.net Sender: "buildroot" From: Pascal de Bruijn This makes PostgreSQL as robust as possible by default Signed-off-by: Pascal de Bruijn --- package/postgresql/S50postgresql | 2 +- package/postgresql/postgresql.service | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/package/postgresql/S50postgresql b/package/postgresql/S50postgresql index 3c0c520..ce72e12 100644 --- a/package/postgresql/S50postgresql +++ b/package/postgresql/S50postgresql @@ -7,7 +7,7 @@ umask 077 if [ ! -f /var/lib/pgsql/PG_VERSION ]; then echo "Initializing postgresql data base..." - su - postgres -c '/usr/bin/pg_ctl initdb -D /var/lib/pgsql -o --locale=en_US.UTF-8' + su - postgres -c '/usr/bin/pg_ctl initdb -D /var/lib/pgsql -o --locale=en_US.UTF-8 -o --data-checksums' echo "done" fi diff --git a/package/postgresql/postgresql.service b/package/postgresql/postgresql.service index 4bbe742..2f5d2a9 100644 --- a/package/postgresql/postgresql.service +++ b/package/postgresql/postgresql.service @@ -17,7 +17,7 @@ StandardError=syslog SyslogIdentifier=postgres PIDFile=/var/lib/pgsql/postmaster.pid -ExecStartPre=/bin/sh -c "if [ ! -f /var/lib/pgsql/PG_VERSION ]; then /usr/bin/pg_ctl initdb -D /var/lib/pgsql -o --locale=en_US.UTF-8; fi" +ExecStartPre=/bin/sh -c "if [ ! -f /var/lib/pgsql/PG_VERSION ]; then /usr/bin/pg_ctl initdb -D /var/lib/pgsql -o --locale=en_US.UTF-8 -o --data-checksums; fi" ExecStart=/usr/bin/postgres -D /var/lib/pgsql ExecReload=/usr/bin/kill -HUP $MAINPID KillMode=mixed