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.96) (envelope-from ) id 1vlB1D-008L7Y-2x for pgsql-admin@arkaria.postgresql.org; Wed, 28 Jan 2026 19:16:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlB1C-0033YU-0b for pgsql-admin@arkaria.postgresql.org; Wed, 28 Jan 2026 19:15:58 +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.96) (envelope-from ) id 1vlB1B-0033YL-2V for pgsql-admin@lists.postgresql.org; Wed, 28 Jan 2026 19:15:58 +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.98.2) (envelope-from ) id 1vlB19-00000000vPN-3CP6 for pgsql-admin@lists.postgresql.org; Wed, 28 Jan 2026 19:15:57 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-b885a18f620so27443166b.3 for ; Wed, 28 Jan 2026 11:15:55 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769627754; cv=none; d=google.com; s=arc-20240605; b=jyE18PrZD601wnRE/0S1RIiGAlQwSjNZFwsO3hKIjyR3/qQpB8p6Hm1UJlvqtbGzow QlqsOI6ZCViX86L8Sk7aZYoIuRBpgMNhG9fjxYHNrWfr50DZGou/JCtdOOvTqW1dhRDi DrSHjWX+k9SjW6M+z2OUP6YmsVyo0Lws/5gHBG4J1Vt22Xorq8ymotY25rM5ax4JqE1V h2oxjrgqJ5o05cqIZDO7rqZ+JkcWmeA2kdwjkVleCuSSaMFkBGTaZZycK/HDGgdrYiOt c6oTn6HTxrWhargv76aSn86BL9b7wiB2mg+flsnSr6YMEYQ5iEapAefv3b8voYlJWs7w fvYA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=WxFefQmbr+CIQ6xYDR0R9jwjB/mbx1RZLqZOBSqUhHY=; fh=kJJPHglQ+cCiZxP+/VgmvINxKXMgdX+Jj7LrbAUPgm8=; b=d8L2vYE8ngLiUHHGkZhIIg84T8nOECZ4n63X7PGZqQsYKKhPvvorWcqpApD3TytIN4 EVJ5AFnX8vW5C8/DTa227LMv8UUYZLvfUnQ1+mcK/49k6w2E+9T1YSg95mX+JCTrLswZ NMDKwbZRY1FfnEeBEeOJ3blwOTN0439vEAkuIrP4jU9tVibUpUL6ZU5oEoH8Kp9k9ruq 1rwP3uJESHw9Yw3/n0BQvJ0rhuvbVn1sBJSAbC1w93dcO9zlRpI/bnGyOP+qbtsJ6pNH sJlcbJhGGacvNJRxRwPNk6UuQZEqH7B55S9F/zF0unIGc+jlmRgm0DizE3rbLzkfzM4I Ly4Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769627754; x=1770232554; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=WxFefQmbr+CIQ6xYDR0R9jwjB/mbx1RZLqZOBSqUhHY=; b=XfksEefHJuyLKc+7jEHQiGnZwxqTKFnZ0CeDfxGLed5qnZjvYlo+3HD2uH7QhqeLJr gKKqYx50+MtAFShaDzQ9uRu3kJNdMuUuq8BnOSXdmtea83hExRshOTPqUSKfxocPd0eH n0BHYV0KxvNd/gUJGojdhv/MmvEoO6d4F67kO8g9DUvEscrJURKwfZkvzvQ4gmnGjBWA gVD+HvULyrA17oP/nqc5HrHaqYlkR+PBtbXUl3Swjwn6MsUwwOVFK/XUkpoXSFuj6VNk e6ky/3mPAwuECpvwVL4IGDvnwlpPDg4K5sGfp7N0yGjRAegfmZqHsqNYTFHJ773YEPQQ uMgg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769627754; x=1770232554; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=WxFefQmbr+CIQ6xYDR0R9jwjB/mbx1RZLqZOBSqUhHY=; b=Zge5OF4Ank0YRizb2bt2vEF0gXC19X953actXo9LY9L/0qjrrZDE6P3C8WFxWlD45D 2PJ9nU0nwrGuv0UcWjsGeH9vFuGJ71iflsMiJMZ2ial+Ci6fV/0HxVtZyBlkBcUMqeuL 2P1mCa5hPGX2tc0NCCyRJdahd0nRB7lfcH9ar4V3pBpYRrxpmuxWWxPUj6LGFkcQcwFI bOoibvGGPh2TNNsbI9wQj+400oz3c1G5lfbhf1Xwn/jqV/kGVHoMMhdYXDRHwh5PoQlX Kz60rFdifz6TDC9gaOmAo7JQwwhEVIqsRd5eNTSof1m8fvlhDvlH3+eBzt8069M/3SdB j5dg== X-Forwarded-Encrypted: i=1; AJvYcCV9KkkAW47u9B1LPvT///V/dQPWcj95pbmp5pHBsL3Oqd2MU7t68r3SplQr8pJmZ2+IXdk2cNRldpLlcg==@lists.postgresql.org X-Gm-Message-State: AOJu0YxDGfCiwJhIUaY3ORj59jLAF51G2yZfm9GWEoZHL+uBRbr9QArN jMGrd7i1u5CAwNL8aCpg320mW0OB3PKkJLC9mqOw5Y1w7GyVScB3sxWQCo82OkbLBl2O4n6HdBr VFgUJL5zgryv6dFOS0XCaHGduPCqyJKylaYqj X-Gm-Gg: AZuq6aKOGc/6MgvVBR7afOkAmfREkHipntjz6dU9ZriCejImoLztfQt+QkvoC4ArDOS P9odo/xoOyVbHMI/c0stF8SFioZEOsEiFlgWqRPsLMwE2gZ6zqBq7NKcBSdl348tKI9Vuz4U7H4 bfDHE18bR0Sgi0OfsgH2JlnNPjoVVLupFz5K3C/Aaj9TYpklmCqYKF8A3bxmrzcZAn3IonRMKTh H8gRvnzqiDkmRI5n/WsgjM/a5uqPXHXTtx7EVXSCahxRBBnEh6Ykh5Mn8KNiGu7lJ9+H2Tvjw== X-Received: by 2002:a17:906:fe4b:b0:b88:5957:2d65 with SMTP id a640c23a62f3a-b8dab420adamr440685866b.37.1769627754340; Wed, 28 Jan 2026 11:15:54 -0800 (PST) MIME-Version: 1.0 From: Wasim Devale Date: Thu, 29 Jan 2026 00:45:42 +0530 X-Gm-Features: AZwV_QjQwAIy02-Nce626nYYP1mRRQa_PY6mmXi_f3Xo0FGN0dva9kJ2x2z8MV4 Message-ID: Subject: Restoration process generates 1.2 TB of WAL files. To: pgsql-admin , Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000aea6df064977916b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000aea6df064977916b Content-Type: text/plain; charset="UTF-8" Hi All I am taking directory dump from postgresql 12 and restoring it on postgresql 17 this process create 1.2TB of wals files in pg_wal directory. Can we reduce this WAL files generation via any configuration changes? Thanks, Wasim --000000000000aea6df064977916b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All

I am = taking directory dump from postgresql 12 and restoring it on postgresql 17 = this process create 1.2TB of wals files in pg_wal directory. Can we reduce = this WAL files generation via any configuration changes?

Thanks,
Wasim=C2=A0=
--000000000000aea6df064977916b--