Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1snaF5-004d4q-Rg for pgsql-admin@arkaria.postgresql.org; Mon, 09 Sep 2024 08:59:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1snaF5-008eG0-A4 for pgsql-admin@arkaria.postgresql.org; Mon, 09 Sep 2024 08:59:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1snaF4-008eDp-Th for pgsql-admin@lists.postgresql.org; Mon, 09 Sep 2024 08:59:26 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1snaF1-000Gxh-8y for pgsql-admin@postgresql.org; Mon, 09 Sep 2024 08:59:26 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-a8d51a7d6f5so88612066b.2 for ; Mon, 09 Sep 2024 01:59:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725872362; x=1726477162; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date :message-id:reply-to; bh=dPadWKULRfvPyI3KBRB+W5kF3rcJVkS/2STmKC/FTMk=; b=euRE0abe19Pq5qAB8hJtshUNWQOibstI4uzBmURru7h7xNdcLGKJvZtsFop0Dwkcjm 0e34LMV2LARXhue+orp+HCpN5zlT7daj54KjyQgD3difY+AKFltfnYbB9Bd54vHvTGyq JJ0Xvo3kknvbGGgAUGMpfxSlX9zO8EokOJcwEAowOTYAzoGUP6zYXPh3KCasdgAVykgf MBGHC/OTXmg51s2bJveMitL77L+bhc78yiR/tsYmYJiwOBNAdFqS9KnA3KmQzFZNuXKC qAHAPuVwOWXtxd8o2zpSDWHx6g6mQYwwAQI7cts4EfE3lyhKNPO38b/c8Zlf/5SzhKpA fy+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725872362; x=1726477162; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=dPadWKULRfvPyI3KBRB+W5kF3rcJVkS/2STmKC/FTMk=; b=WiZVEiS1ztBM3I+wz5lQZggABuYoZlQetGsB7IaD4zzVKAG0HyIOwWUvxIoUlit9Xe kHXhpSJNfSyo73oixTnTmDgfVcjIhXtkdmuJF6NeKItoZSPvDI07aEdL2uDps4v9CnyB 6sCRIU8oLiTNEHdbendZf9K/RSfkVADNpTlpnYGMc+oNbCYOr/IPs6PwCHe7F0xmmqpq Omi9AASDv2d3WaW9sy9IgxOtmbpl2lR25rIzew/5LGPxAhDRhgfY/saw8TYbTBd6VMiu L27mEAHqFahLUEzpuf1PDjE6Hent2wJujuYzhs7ZB28wxhXSqIDNYh6b/GFgt2wJc51n wemA== X-Forwarded-Encrypted: i=1; AJvYcCWP2h0Yqqwf+OgYotFfNxaSEE4aGmMA3U7Tm17qT1zpXqLxDpZrwRQVJk1L8fXw9EYOWpakxa1sfOjtIw==@postgresql.org X-Gm-Message-State: AOJu0YyDzGODjri/7wJNjenPQ5/CWTux/9CL9/zn+3uikz2Z/AiqWH4R hrxnT1O0dvOLWOgbzFYUx6yQOURY0FnMMjoUjG4++y1n3pqG97yA X-Google-Smtp-Source: AGHT+IElDTF3j6udy0SPy1hYZ8+9zTVVpR2yuADPbEFENdzBwyg3A7CRiU/Te6biJVo30bX0ZcoUoQ== X-Received: by 2002:a17:907:3205:b0:a86:963f:ea8d with SMTP id a640c23a62f3a-a8a88870ec2mr880029566b.64.1725872361664; Mon, 09 Sep 2024 01:59:21 -0700 (PDT) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:10a7:1a01:2a0:7804:2d71:4b2e]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a8d259511c0sm310477366b.62.2024.09.09.01.59.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 09 Sep 2024 01:59:21 -0700 (PDT) Message-ID: <66deb8e9.170a0220.2d507.8cd3@mx.google.com> X-Google-Original-Message-ID: <20240909085920.GA17063@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1snaEy-00044q-K5; Mon, 09 Sep 2024 10:59:20 +0200 Date: Mon, 9 Sep 2024 10:59:20 +0200 From: Michael Banck To: Wasim Devale Cc: Pgsql-admin , pgsql-admin Subject: Re: data_checksums = off References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Mon, Sep 09, 2024 at 02:24:04PM +0530, Wasim Devale wrote: > The data_checksums option is off in pg_settings and it is a preset option > to do while doing initialisation of data directory. I can not use alter > command any solutions to it? You need to shut down the instance and then run pg_checksums --enable -D Checksums cannot be enabled while the instance is online and the above needs to rewrite every block so it can take a while on larger instances. Michael