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 1wefCH-004w3g-31 for pgsql-general@arkaria.postgresql.org; Tue, 30 Jun 2026 20:36:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wefCG-00A6pQ-1y for pgsql-general@arkaria.postgresql.org; Tue, 30 Jun 2026 20:36:44 +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 1web9W-0095Wd-0W for pgsql-general@lists.postgresql.org; Tue, 30 Jun 2026 16:17:38 +0000 Received: from mail-qt1-x833.google.com ([2607:f8b0:4864:20::833]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1web9U-000000012iq-0DDP for pgsql-general@postgresql.org; Tue, 30 Jun 2026 16:17:37 +0000 Received: by mail-qt1-x833.google.com with SMTP id d75a77b69052e-519eedc30a3so45186291cf.1 for ; Tue, 30 Jun 2026 09:17:35 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782836254; cv=none; d=google.com; s=arc-20260327; b=AYg+YO8F5hJ9PQT3U32zwZ/FgbgyAAMUHQPO2UAjq3fdftGCro5zeae7cc1bxuQZQk E5LD2FfJSm8LAyfsXz9I6+QSrwzBXSV8EUfILR4V9X7+/0KkAVTwdOHODkuQ4lSGMT0Z oM1kKOErwlpWpdCKlgiIdS13HobG/YGMwyM/UMxMayxkrTIZgHEaOljkVbZu0tR3MPyB JeZa+90ePcQyExGFlH2Gr2zQD410WV+8wU3vFOHZujS0cc+ilKJJ/DTr99jejxwxfaVK xYUphJKxtAZmJsnCuaVNI1qrM0MPe5u734DyUD1nMxDZKqnfHeXcgs/pzY/DqQUWpIwB a5/Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=A/iYmJoJQVB0xUKYCaM2gyBGheIBPZfVo7OKKLqP62s=; fh=x9Jmr8+FtiCQKUvo/7/je6SkcsG+V48pI/LmEXQOSec=; b=bAH6bbUMOM9wvNqcAlqHShLAX16LXCRP3mpRzRh5FlA1k8V1uU3pYaF9xKhNXVMfeE iNFr6R9uHQ/3fNuu4W362AR216TSExKPdnySJY5mXkfJvE517m6GmOkmgoZmqshzw5Fp nI2VkhiBUhnnuQECxzlNlD7d1ITj6rHuD10Lsfn/S2tcj99jI2tbXAHilc6DM2QXuRdx ah/tNWbNZTqt/A6T7ObjL4kZiplcGwuwXR004VpycaHHuePCgaI735MlCvF+8R9jCtey PdoLshcft4c7uJkdLo6lEZzNEwjMXU2v4Tcz8QqM4b3wv+33rtqdvOxAGeIkXynOX7Ns GT4Q==; darn=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=20251104; t=1782836254; x=1783441054; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=A/iYmJoJQVB0xUKYCaM2gyBGheIBPZfVo7OKKLqP62s=; b=QcvBQ37D+jRxM67NRVGBoGaAOTI+rqXVvvnhNDgtrA1Jc/EvRWr85SAzPNMrjaNulz 2aT5grZ9l67xOkLMP1EtcUV9+BKB2kDEPs98wPGJSJGYokGWOWVHZXI/NRNDqJEkBTPM BS5ETDdVCxm8qvHP5Te55oelcMWCukrtJ+setU5zawddH+XOb22slLFH68j/hQFbVUvE NHddeE5iieqDFY49OPhABfceYeVCzetjkUUinLIstMegq0f30nosDqVwv35qPJca1Cg3 GhyU+1lkO1duhudrztA7o0xivFmGwuL+9RfF8Zas/0rGPJWnMhDORKkt3T674MeCv9jH U+1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782836254; x=1783441054; 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=A/iYmJoJQVB0xUKYCaM2gyBGheIBPZfVo7OKKLqP62s=; b=CJrhwHRcPe1/1SiSgj8xKP9h8UFDsvkZ/haz7SZwQPlYnUhlvPbpOH24sytJe4dwjP Cl1GHTJsPUmj3/Y59lTor/q3enRyW1YAdEXt8IGm9/SeuXFL0Iv8BfLFjgQjxJLdt+LL aMWVkDJyLwUGRIs1bjX9Rij0ZRNDvuAk0DwTdTupuH0NDpLc8qqSGOsL2eA6dcOKvD5M bPZkIMe5dNRCYYNHxqrRXis7B1g7IE2ymyVloyibAX6Tkz48OeLxMDKchXvi6thu9xzY CCqToAfqE6Ek2aFK3Yzv9Z067VHZHxcLDOObzn6jqXpzql1NqXnhMs4hI2DcX6oTQXRm WKgA== X-Gm-Message-State: AOJu0Yyt6zq1MUSiFq6EH7iqOpJPg83YgamXIOKKZrmDMnYvgSTcfsHp 6rG7AEoV0437YhM/ssp51NIctFKde1T0uPbWcbfh0DDOk0Lq7A3Tt02vlNgMb7BF5Fu/9vha2pp hEa0zGlTP+yYCaChPtd3vg0T/pkSDhvNPeGNZ X-Gm-Gg: AfdE7cnFHUYu6zwNlikzHJh80t6gZbeZ9WnnDvJrqQZJ4uELmdnhgE/kbfwjIYka3wV QKOzfuYyKuqiWWezDrv1npni0VfF1nPxOEYcQ8pxZTzPXrrS3A/0D7aTD6UTn5I68SofKCYELv8 VOFbCrAmrdq5mgjNWBLTyDMIqBzpe3erbxvBBqgZVLbm1M5IQZT52RjbWa0Mw/eSHsT2skq8omU O1A4vYdwy/kzG/pE+fyTnPG0FHOC50tY0agf+vl0vK1PID6wE9rYlao9EoCnbcFB24nVHaXX4LN GPXIeVbs X-Received: by 2002:a05:622a:4ce:b0:50d:900e:c1c1 with SMTP id d75a77b69052e-51c1c8e4f6fmr18599931cf.7.1782836253532; Tue, 30 Jun 2026 09:17:33 -0700 (PDT) MIME-Version: 1.0 From: sa sa Date: Tue, 30 Jun 2026 17:17:21 +0100 X-Gm-Features: AVVi8CeR-RuXPSGregklsaEYrGIch1nyHAoy_ymhBCntKj41CtsVqnoIByob-jw Message-ID: Subject: Postgresql Wal archive and Barman setup To: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary="00000000000095a54f06557ae9ea" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000095a54f06557ae9ea Content-Type: text/plain; charset="UTF-8" Hello All, I have a scenario, where I need some suggestions and improvements if applicable. Our setup in brief 1) Primary --> standby using archive_command = rsync to primary local location and standby local location 2) Primary --> Barman Using streaming. Barman backup location is /nfs/DD9 3) Archive cleanup on primary is setup via crontab to every 14 days. Here is my scenario, If my barman nfs is down for 5 days and my local archive location is filled up during this time. what will happen. if my /srv/archive (location archive wal location) on primary and standby is 100% full during this time. my /srv/data is going to be 100% full , causing my cluster to go down. So what are the suggestions to avoid this situation. Thanks, Sa --00000000000095a54f06557ae9ea Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello All,

=C2=A0I have a scenario, whe= re I need some suggestions and improvements if applicable.

Our setup in brief
1) Primary --> standby
= =C2=A0 =C2=A0 using archive_command =3D rsync to primary local location and= standby local location
2) Primary --> Barman
=C2=A0= =C2=A0 Using streaming. Barman backup location is /nfs/DD9
3) Ar= chive cleanup on primary is setup via crontab to every 14 days.
<= br>
Here is my = scenario, If my barman nfs is down for 5 days and my local archive location= is filled up during this time. what will happen.

if my /srv/archive (location archive wal locati= on) on primary and standby is 100% full during this time.=C2=A0
my /srv/data is going to be 100% f= ull , causing my cluster to go down.

So w= hat are the suggestions to avoid this situation.

Thanks,
Sa
--00000000000095a54f06557ae9ea--