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 1qwSEi-00BmZc-51 for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 19:11:12 +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 1qwSEg-000hci-64 for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 19:11:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwSEf-000hcX-RH for pgsql-general@lists.postgresql.org; Fri, 27 Oct 2023 19:11:09 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwSEd-002cL3-6V for pgsql-general@lists.postgresql.org; Fri, 27 Oct 2023 19:11:08 +0000 Received: by mail-lf1-x12d.google.com with SMTP id 2adb3069b0e04-507a0907896so3466991e87.2 for ; Fri, 27 Oct 2023 12:11:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698433865; x=1699038665; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=cJt923ilPqqnbZ3vt0YZge8ZSf2JKfynvK51SheLp/I=; b=ZS2AkZnf13I47wPJ7Ye5UatCJ09oxHWZurm6w08jWBcpXgmcMYmUv950QPBxTnvwlV +RVn3uzEMvUN7RFtp+TnozrXmrZpwxikSELWsFLMIvkaFeShWIoJeH7CSzyQn9/M8Y3P fw+I6O7DpHhNi2EKlt3e328FNYTKFPBa4Tt0hXbjv5QRW5B+wsBiovRUHx29mTP302v+ rtqjpZsieHeK41EpJQO3YukDl3dftDtobK8/QxS1nekGTal5Whf3BiEOpJLIprLagsYP Beho5QIwj3Qyvuq7RurBiOeI3G51p/VJV+ZHQnsIe6iUCLLPh/vRdlNa9LAoA8D9KU2k VOJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698433865; x=1699038665; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=cJt923ilPqqnbZ3vt0YZge8ZSf2JKfynvK51SheLp/I=; b=v9NAPFilrDnQEMWubqkLQCNanazCMd9vKQWv/iCd+3rrmjpYaZvl9rnUWlxb3iVUeS nKmpYUmuLxY+CyQzLH2NRvEuFTn7sk9tGRpzrPr2/ViYkeXXoFHyzsF+F32hsoPFQDjZ 6sKbmYy7Xr3UspLss2eQMdN7V/pEWVmqM1B6iNHDm+9MR7sIY4LH19nSKHjRRW4c7l59 0tOaLjuN35g11svD2ZjNa6N0k75bCy+vBKMAj99BleJCj2EFm0+gh4VoEoooKEM11itd ZOhg47ZYWcfOOqE0UDTL8hGWt+XGN3IvK/Zzd5XSUhrJxr/jqoj5+sROF6U19wYYXUAm MOCQ== X-Gm-Message-State: AOJu0Yzv+NoAZRxbIyBd032ko/NOmPMMRPANpKgWgiiABUsTBTrEuKsN NDC5Qfx3pWkD7SqYMEAOPRY= X-Google-Smtp-Source: AGHT+IHG3OTZoYQdAjAvqIZhmbEzywFjR1/VWVsKpKuGA6CdmhWYBuwf34n8x6Yqy6iioajUgh8wZQ== X-Received: by 2002:a19:ac4a:0:b0:507:b993:bb86 with SMTP id r10-20020a19ac4a000000b00507b993bb86mr2433332lfc.66.1698433864351; Fri, 27 Oct 2023 12:11:04 -0700 (PDT) Received: from smtpclient.apple (26-36-239-77.dyn.cable.fcom.ch. [77.239.36.26]) by smtp.gmail.com with ESMTPSA id 16-20020a508750000000b00534e791296bsm1660572edv.37.2023.10.27.12.11.03 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 27 Oct 2023 12:11:03 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.200.91.1.1\)) Subject: Re: pg_checksums? From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: Date: Fri, 27 Oct 2023 21:10:31 +0200 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: 7bit Message-Id: References: <22272207-E6E5-4DD5-9BD4-5F6B647E2C3B@gmail.com> To: Ron X-Mailer: Apple Mail (2.3774.200.91.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Ron, > On Oct 27, 2023, at 21:02, Ron wrote: >> b) why isn't it possible to check whether checksums are enabled or not? > > (This is my tiny test instance.) > > $ pg_controldata | grep checksum > Data page checksum version: 0 > > postgres=# show data_checksums; > data_checksums > ---------------- > off > (1 row) this helps a lot. Thanks very much. Now, there are only two other questions. Cheers Paul