Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d82QC-00077e-C1 for pgsql-admin@arkaria.postgresql.org; Tue, 09 May 2017 10:31:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d82QB-0004UW-Uz for pgsql-admin@arkaria.postgresql.org; Tue, 09 May 2017 10:31:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d82OM-0005rK-Eb for pgsql-admin@postgresql.org; Tue, 09 May 2017 10:29:18 +0000 Received: from mail-wr0-x22c.google.com ([2a00:1450:400c:c0c::22c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1d82OF-0001zm-Bh for pgsql-admin@postgresql.org; Tue, 09 May 2017 10:29:17 +0000 Received: by mail-wr0-x22c.google.com with SMTP id l9so66312759wre.1 for ; Tue, 09 May 2017 03:29:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version:thread-index :content-language; bh=2AbjtVJcyE4o1lUJ1DMNZxBceCyEKDfcgafbARgSyTk=; b=Ss9mTS8QJhhZyolBnX2IUibyTO2nKsbswqGu1LyyUepKmLTFiXWVlJVCFjnDvygzsv 2dn2hwWajVbY0GWx4ac+DkF61UsTwWpEGLR2AGyrg6hDCzf1TlwSh3qIz5+LdCJoM7F+ b+xZMv88g5xTNxyL7eDTj1ASxsnoY/zpZJUb5XXO3/dReX7z9SltXCVxYtAUlgOw0aPS 4K+/Ga38UAg28dSwMj4sOKIgkfLRYZXX/I4up4eepxsCJy3DB3pQV6x3OhTTSD1Gg4fr EggwN1FmLq1eJX/Gj0T6vv2QZgi0QNNOgCI4vsWE2U4mQKGAQScvnblZoyV1wQvBBIpw gD+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version :thread-index:content-language; bh=2AbjtVJcyE4o1lUJ1DMNZxBceCyEKDfcgafbARgSyTk=; b=mfDa6ftfpzPZqn57iakaDhrFni5g76TMP2e1bmgdFegWIwr9fSmKUOZhzYm7jIS4R5 w/Ruz9Ezk/z0pXuD7ztzjt83Wdki3csufhkIc9JKTFUQPDN1apREiL687UboPBmnMHae N745epPFwSLjvRnDhbZD9kcjn9S822DE8PrSUk9N8zZ6rSCoWGZUnT7txtOeoyqfdXR5 TNFBmhwhErH7VjPXEKM4zcaOjMc1kPak5aj4uMW/GSUjum1cMq/KWYX+5uInYAD2OIr/ uDrtKakZBKHULb8f9Ke3z78Knq/M+d6DfcQzmowbxeBAR8r5aBmltXrMLorFR6gej+n+ KhEg== X-Gm-Message-State: AN3rC/6MhRlntcYwYp7G1YP7e+BLrdNgq3k/10AJOgqPENeo1QazWVs+ t4vGDriU+uBONbUf X-Received: by 10.223.171.68 with SMTP id r4mr43909454wrc.67.1494325750383; Tue, 09 May 2017 03:29:10 -0700 (PDT) Received: from PC14 (mail.ibeq.com. [212.100.42.241]) by smtp.gmail.com with ESMTPSA id z14sm583195wmz.2.2017.05.09.03.29.09 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 09 May 2017 03:29:09 -0700 (PDT) From: "Klaus P. Pieper" To: Subject: Windows installer initdb with --data-checksums Date: Tue, 9 May 2017 12:29:08 +0200 Message-ID: <00d401d2c8af$1807ebd0$4817c370$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00D5_01D2C8BF.DB917F20" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AdLIrgD15MTeHQw2SXWoxaLjnpPwVA== Content-Language: de X-Pg-Spam-Score: -1.7 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_00D5_01D2C8BF.DB917F20 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Is it possible to run the Windows installer (from EDB) and have it creating the cluster with the option --data-checksums? Or do I have to install it in the following way: - Install - Stop the service - Delete data directory - Re-run initdb as NETWORKSERVICE with the necessary parameters - Start the service Taken from here: https://serverfault.com/questions/574474/completely-reset-postgresql-to-defa ult I looked into the manuals but couldn't find anything on this subject - I may have overlooked something. Thanks Klaus ------=_NextPart_000_00D5_01D2C8BF.DB917F20 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Is it possible to run the Windows installer (from EDB) and = have it creating the cluster with the option --data-checksums?

 

Or do I have to install it in the following way: =

-          = Install =

-          = Stop the = service

-          = Delete data directory =

-          = Re-run initdb as = NETWORKSERVICE with the necessary parameters

-          = Start the = service

 

Taken from here: = https://serverfault.com/questions/574474/completely-reset-postgresql-to-d= efault

 

I looked into the manuals but couldn’t find anything = on this subject – I may have overlooked something. =

 

Thanks
Klaus

------=_NextPart_000_00D5_01D2C8BF.DB917F20--