Re: Postgresql Wal archive and Barman setup

From: Venkat Akhil Pavuluri <akhil(dot)venkat(at)opensource-db(dot)com>
To: sa sa <ssmaugust(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql Wal archive and Barman setup
Date: 2026-07-01 07:28:24
Message-ID: CAPCUgKrSm3rqQ=yqS-SbFL5awaBN=pT=uxiurhPx9PH9cRaurA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi sa sa,

As per the best practices, maintain different mount points for the data
directory and the archive location. In your case, data_directory is
`/srv/data` and the archive location is `/srv/archive`, meaning both reside
on the `/srv/` mount point. If your archive location is on a different
mount point, your archives will fail (which will have its own
repercussions) but your cluster will remain operational.

And also having alert system to send mails will help you as Masheed said.

Thanks and Regards
Venkat Akhil P
OpenSource DB
Your Trusted Data Partner

On Wed, 1 Jul 2026 at 02:06, sa sa <ssmaugust(at)gmail(dot)com> wrote:

> 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Michael Engelke 2026-07-03 10:20:57 last_analyze/last_vacuum in pg_stat_all_tables (PG 17.10)
Previous Message masheed ullah 2026-07-01 07:15:14 Re: Postgresql Wal archive and Barman setup