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 1sWWaJ-00FfY3-Gl for pgsql-admin@arkaria.postgresql.org; Wed, 24 Jul 2024 07:38:51 +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 1sWWaH-0026jF-JE for pgsql-admin@arkaria.postgresql.org; Wed, 24 Jul 2024 07:38:50 +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 1sWWaH-0026j6-7z for pgsql-admin@lists.postgresql.org; Wed, 24 Jul 2024 07:38:49 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sWWaG-001Bkp-2e for pgsql-admin@lists.postgresql.org; Wed, 24 Jul 2024 07:38:49 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-a7aac70e30dso61100266b.1 for ; Wed, 24 Jul 2024 00:38:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1721806727; x=1722411527; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=9ntNe72XrOGy0o0PmPL0e6gFHAAPOkpqlaPm5xcSrO0=; b=RBYCF77+3pv14XYkzl9vJJtt+nPPVCmdOGnkELG+NbZYfnhmIM5hrHYRGV1Ct1z3X3 KDYXlk1xgsn6w2Dpj8M39TWMlWk1lTqMvuuf/Lwg0CyTCsr3lpwt3h22GMP1XW+A9/ab mBjioUmO0Kw2Kg3ovF8u69BrHJJEvawkjQ8lVLSuRT9XAYkGs5wPAYeFRb1cAJ/6Jj9n bUZIyiT96VcPFFObyzDjgdU9t8tJ6JRxLobV4iP4y4GDRmBOfLmBtIbLwcOHk+oSpZv0 Ac8dk8PzehPKmxFz0z4ONDR2njx9qqLTbkafQRg+pNBqVXDaptBZ2/rXvknVDlJpauXg pE6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721806727; x=1722411527; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=9ntNe72XrOGy0o0PmPL0e6gFHAAPOkpqlaPm5xcSrO0=; b=UcWcD0jHXfl3VsHJ6KSYdPHv2Jt+of2sk7QcafP9WWTFborKgqgX0o7GClzTJFMhly Qy37yb52RvTreG15dIN0gSygHuYaXecsaRNaQyMIu/rbR8qk+vy9xz6P2QrPcFGP0I8z a4Dbx6fKLHUyZipt0eg2ejguLTrgrAqN5A7BbSGUcb18IntSDeBCehZzQuOLFaQxsV1p 4LFB08kxCRoVqozZ/jqjCHt/IpMxB9vFTGS9y+8qPxALDcS0aaMBTn7zWlOrtDa4B+tE CcxVTXjfZdPUQrGFbH8LCx00JAYwpbbd24QzLBaP4EZ9wrfDPojMhSsqMVqzon2fIBzX 8J2g== X-Forwarded-Encrypted: i=1; AJvYcCUK2rzbxzP+JutaKlzBL9theafzdp9y5HUgYzBmaGNQMlUzknbLRDpi/IbCls3Aj7+moPl2r4/NBUwyJB+ydGYWE+Nfg2+l9L/wMob3a8KyHw== X-Gm-Message-State: AOJu0YytSi0KnmKjascUw1f3zf2mx/03qa9slToB+nm8BPh4qQgQYLcE zEOS6YbCj7DONxL4nuaYCZLgyjf9VWg9UiLJX1tK3LEZspl4F05qzYNcBYP4qtIZCJljlnebtyG B X-Google-Smtp-Source: AGHT+IGyywf+fXvxA0TckuthfcFkgwRGwLKTNgbOvIGGDt1AAEOhkQG/eXS1ppFQuWFS8EiVJvwy/w== X-Received: by 2002:a17:907:7d8e:b0:a7a:a7b8:adae with SMTP id a640c23a62f3a-a7aa7b8afccmr201679166b.4.1721806724889; Wed, 24 Jul 2024 00:38:44 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:ba6d:bf11:107b:5b76:b25a]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a7a3c95088fsm613206266b.212.2024.07.24.00.38.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Jul 2024 00:38:44 -0700 (PDT) Message-ID: Subject: Re: pg_basebackup not completing From: Laurenz Albe To: Somnath Som , Pgsql-admin Date: Wed, 24 Jul 2024 09:38:43 +0200 In-Reply-To: References: Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-07-24 at 05:55 +0000, Somnath Som wrote: > DB Size 114GB, when running to pg_basebackup then its stuck in 99%, full = backup is not completing. > Postgres Version: 12.16 > =C2=A0 > Backup Script: pg_basebackup -h $PGHOST -p $PGPORT -U $PGUSER -D $BACKUP_= DIR/pgbase_$(date "+%d.%m.%Y-%H%M%S") -Ft -z -Xs -P >> $LOG_FILE 2>&1 > =C2=A0 > [image showing pg_basebackup at 99%, immediately followed by a shell prom= pt] The image looks like pg_basebackup completed successfully. Perhaps the display didn't count up to 100. There is no error message and no sign that the command was interrupted. Look at the return code right after the command: echo $? If that is 0, you can be sure that the backup was successful. Yours, Laurenz Albe