public inbox for [email protected]
help / color / mirror / Atom feedPostgresql Wal archive and Barman setup
3+ messages / 3 participants
[nested] [flat]
* Postgresql Wal archive and Barman setup
@ 2026-06-30 16:17 sa sa <[email protected]>
2026-07-01 07:15 ` Re: Postgresql Wal archive and Barman setup masheed ullah <[email protected]>
2026-07-01 07:28 ` Re: Postgresql Wal archive and Barman setup Venkat Akhil Pavuluri <[email protected]>
0 siblings, 2 replies; 3+ messages in thread
From: sa sa @ 2026-06-30 16:17 UTC (permalink / raw)
To: pgsql-general
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgresql Wal archive and Barman setup
2026-06-30 16:17 Postgresql Wal archive and Barman setup sa sa <[email protected]>
@ 2026-07-01 07:15 ` masheed ullah <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: masheed ullah @ 2026-07-01 07:15 UTC (permalink / raw)
To: sa sa <[email protected]>; +Cc: pgsql-general
You need to actively monitor archive location to avoid space issue.
Schedule a job to send alert email when archive location full to 80% or 90%
Best Regards,
*Masheed Ullah*
On Tue, Jun 30, 2026, 11:36 PM sa sa <[email protected]> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgresql Wal archive and Barman setup
2026-06-30 16:17 Postgresql Wal archive and Barman setup sa sa <[email protected]>
@ 2026-07-01 07:28 ` Venkat Akhil Pavuluri <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Venkat Akhil Pavuluri @ 2026-07-01 07:28 UTC (permalink / raw)
To: sa sa <[email protected]>; +Cc: 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 <[email protected]> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2026-07-01 07:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-06-30 16:17 Postgresql Wal archive and Barman setup sa sa <[email protected]>
2026-07-01 07:15 ` masheed ullah <[email protected]>
2026-07-01 07:28 ` Venkat Akhil Pavuluri <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox