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 1m2uw1-0007WR-Dq for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Jul 2021 12:21:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m2uw0-0002EG-9q for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Jul 2021 12:21:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m2uw0-0002E7-2L for pgsql-hackers@lists.postgresql.org; Mon, 12 Jul 2021 12:21:16 +0000 Received: from mail-pj1-x1030.google.com ([2607:f8b0:4864:20::1030]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m2uvx-0007SS-LK for pgsql-hackers@postgresql.org; Mon, 12 Jul 2021 12:21:14 +0000 Received: by mail-pj1-x1030.google.com with SMTP id v18-20020a17090ac912b0290173b9578f1cso1534732pjt.0 for ; Mon, 12 Jul 2021 05:21:13 -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=z8wLOovW02uPG0pXueRLC6A1Brp2XK8fAB3bUWBd/1Q=; b=q94PoKwlJGvYtVyEpjDcT3uphSgQpgfmf/cdLynmODQCx5x8JMIiSnCaJzQBC1Cy7n Sj28QGm+Y/RYRFx2HnmCxdiOnwHoeHy6zN67KyisLZn+mAiyfEBwE770Fttp320hRZNQ i9mw50q3XhFh2d6JbdTodZt7P7RUYCCT4LPyNtVfR5pFWxZsxUJQ0iMvyuUvt7+17i02 kb59QKU7VMDlVcl8l7WFtNNAweUo3a551lTvYkSsDByDvpB1mmwTDW0OOW5wYkQj9moN 1WlR5ggs6Wt5xvIW8B2X9LsgIBkd/EtFgi19KSbUqSXR7eEZDQrj5Ppo8bfpwwmOh6c6 u0tA== 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=z8wLOovW02uPG0pXueRLC6A1Brp2XK8fAB3bUWBd/1Q=; b=kZzuc9Y7B5nZdnBHehUqFefsH4+C/U1eejKTb/16A3BcT1rnQUqjLNHHIPHb/Kt8l5 h297ZNq/FANGppLcwD9UpCPk3PCYmwp9K8tDwiwv6EH5FT0uRerAlqKnsXzWbzoj/Tz0 0fzzT38hbn4ooAy64a3dL78rOyQ9K7Hur6rO8g+932GsFywhV0cK1KUWWexnrXva4Rzu RIcCLN1zkrZUwUK65/UqKgtpGdSQ3lD4h+mCH5tfNc+gADRYjX+4azSbVVHV+Yp7JCa6 u3qJC4t+MoOPxilgOpxCGQaDm8+6wpXEvunIjFA2ra+j401qR8NY9eIqZzm5sAZ5CPTG jYtQ== X-Gm-Message-State: AOAM532UEHL2lQOk4adJTrXwg3fuOJuXCxLrjWKdfRrizcRZCXsATR6o Spd4AOzRbSkf/oxp2eB8upWSLvzsXugnfgHESmng0g2TTeJ/lFDbOAXovJKpiZ1tFpm+4+WHs0Z AVnR6udVuUbhW5bt/7EH2IEy/dyEykS/Y860YaV3lOe7Qs3OGBgEZlmqJNQEikgV6tEGawPRheq x2kQFyBVFjIeph8z2tmQBtKZPrNUm3Ay82zpNg7RcYeIuFrtYKKiWNTWO2VU+p9t6dbNtn/3gXo 2SrmRbWsWGwk7Ezd2WLMs/MK6vdhSJKCzGSTw== X-Google-Smtp-Source: ABdhPJwzyAgjvChKK2fhjVqWd5f1nYSmUoQKoG7bTnGYMFM8rZ2rPvtQ/mi+3fzRTZcPL4tsWvuxFQ== X-Received: by 2002:a17:902:a9c1:b029:129:cfd5:a948 with SMTP id b1-20020a170902a9c1b0290129cfd5a948mr22150524plr.55.1626092471502; Mon, 12 Jul 2021 05:21:11 -0700 (PDT) Received: from localhost.localdomain ([152.57.57.245]) by smtp.gmail.com with ESMTPSA id y1sm2628930pfa.34.2021.07.12.05.21.08 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 12 Jul 2021 05:21:10 -0700 (PDT) Subject: Re: refactoring basebackup.c To: Robert Haas , Mark Dilger Cc: "pgsql-hackers@postgresql.org" References: <58D2BD01-B541-4032-9C0B-B6143841E7ED@enterprisedb.com> From: tushar Message-ID: <4799332e-61ae-3a08-c5da-38f61fa0493d@enterprisedb.com> Date: Mon, 12 Jul 2021 17:51:06 +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: Archived-At: Precedence: bulk On 7/8/21 9:26 PM, Robert Haas wrote: > Here at last is a new version. Please refer this scenario ,where backup target using --server-compression is closing the server unexpectedly if we don't provide -no-manifest option [tushar@localhost bin]$ ./pg_basebackup --server-compression=gzip4  -t server:/tmp/data_1  -Xnone NOTICE:  WAL archiving is not enabled; you must ensure that all required WAL segments are copied through other means to complete the backup pg_basebackup: error: could not read COPY data: server closed the connection unexpectedly     This probably means the server terminated abnormally     before or while processing the request. if we try to check with -Ft then this same scenario  is working ? [tushar@localhost bin]$ ./pg_basebackup --server-compression=gzip4  -Ft -D data_0 -Xnone NOTICE:  WAL archiving is not enabled; you must ensure that all required WAL segments are copied through other means to complete the backup [tushar@localhost bin]$ -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company