Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jo0i2-0004fW-U4 for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jun 2020 08:24:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jo0i1-0008Ua-Nw for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jun 2020 08:24:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jo0i1-0008UT-Bt for pgsql-hackers@lists.postgresql.org; Wed, 24 Jun 2020 08:24:41 +0000 Received: from mail-pj1-x102e.google.com ([2607:f8b0:4864:20::102e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jo0hx-0004Bo-IL for pgsql-hackers@postgresql.org; Wed, 24 Jun 2020 08:24:40 +0000 Received: by mail-pj1-x102e.google.com with SMTP id h22so870595pjf.1 for ; Wed, 24 Jun 2020 01:24:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=p+zyTjee9qJV8XP0i1z4RNeR3j2dF5ymQv3Xtu9Odg4=; b=CD5Paobo31Wml695amq7zQYIHUMN5mCWV9Iv8WqoBzBCo8K+mpGvV5hb/zFfhPtaTo 03Q2YprWD1ztYPq91keUGnvCXbxTe/NYodBWnXhyTcNAOP9LiCKXn+x2WETkOwxAe5Fp xo0tig1ePXbAS+tfA31RbwHc1tULymTWegb7m8CeA1hUY68szwNXiss3k2zfuyf1Khku WrAZOZyM7WvKZa1gnlGAXzzvl5r+q1mJzLKt+mv38uuOfUW7zgoFIHOcMjd4VkwVEzir PUJVIrf4Bymy1koi3D3jWLPKkokZ6duQSPmlPBHx+OoNk7lHf0QP8eN86W/8n/sfavAn S3jQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=p+zyTjee9qJV8XP0i1z4RNeR3j2dF5ymQv3Xtu9Odg4=; b=pC6irLsKVPBjpouZSOV1tafL74wTADPLaThGCdzBA9e9zDH19Cw4bZOhzYvL50c+ij tI/a3yz+K94eswH0cwJqwb085GjWbN3JXZiAaIK8C821lQnjPeF+g9+X0Q1hpKNlckca oT3LDTSfv1yiphP3y9JRLYWOOyf34uSRK6edCx9rpD6ilhfWg0huleycxwLydLKdib/m qodkEN6U+6yVc4A3yXixRO4+J7+D+w7iWg3DVGDKPmY5RlThLS87t9ikoyhrTibRK/8F jmsYlMkK/AYfCh8MpD7/X5VvJ8+Tf1vaQ3Pd45EiU7x++J0M7HTLIBp+iyK/M2vi6FYO 624w== X-Gm-Message-State: AOAM533R6kOiFv4+UqPRcaO7AP2fRKhaNKg71ZZvlbrLBNpkPIRPpeoT rRVTZCnUNDT9q3DOfDjeAAw6HCgIRiRSweHiMDw6LPgke/5NnQhm/vK1EiH71nVl4xjEEyv+mX6 GznAAcfLC27orTQ1WxcLffY/LZ6AJuJRzj//DmgWqXE+J8oQzaRziZt/T2E8lzV0LCboyCxanSo iSTuIPG61fuzxg5d9SDafAKp5SnsTGZdHUKIWeVmBn5i/n9j44OItB/rXsAuGzJT+4lZLCXWieZ Em76ACea69x52mImH6X2MRb8B7r3lHdU5U= X-Google-Smtp-Source: ABdhPJyicocR9KrE8W1aBKZpOF9Gu4YwkpLIo1lFILAuHXbvVNWE1jSdOPlusTtxwW/TLNm4cBBVEQ== X-Received: by 2002:a17:90a:2148:: with SMTP id a66mr13170394pje.0.1592987074395; Wed, 24 Jun 2020 01:24:34 -0700 (PDT) Received: from localhost.localdomain ([45.113.251.168]) by smtp.gmail.com with ESMTPSA id 21sm1482612pgy.20.2020.06.24.01.24.31 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 24 Jun 2020 01:24:33 -0700 (PDT) Subject: Re: [Patch] ALTER SYSTEM READ ONLY To: Amul Sul , Robert Haas Cc: Amit Kapila , PostgreSQL-development References: From: tushar Message-ID: Date: Wed, 24 Jun 2020 13:54:29 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 6/22/20 11:59 AM, Amul Sul wrote: > 2. Now skipping the startup checkpoint if the system is read-only mode, as > discussed [2]. I am not able to perform pg_checksums o/p after shutting down my server in read only  mode . Steps - 1.initdb (./initdb -k -D data) 2.start the server(./pg_ctl -D data start) 3.connect to psql (./psql postgres) 4.Fire query (alter system read only;) 5.shutdown the server(./pg_ctl -D data stop) 6.pg_checksums [edb@tushar-ldap-docker bin]$ ./pg_checksums -D data pg_checksums: error: cluster must be shut down [edb@tushar-ldap-docker bin]$ Result - (when server is not in read only) [edb@tushar-ldap-docker bin]$ ./pg_checksums -D data Checksum operation completed Files scanned:  916 Blocks scanned: 2976 Bad checksums:  0 Data checksum version: 1 -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company