Request a Demo
Home   >   mailing lists

Postgresql Wal archive and Barman setup - Mailing list pgsql-general

From sa sa
Subject Postgresql Wal archive and Barman setup
Date
Msg-id CAEu96cXnBOEiDTC+uCRJwNWqaLT-+ApgA_VOehdfO-9Ntmsc9w@mail.gmail.com
Whole thread
Responses Re: Postgresql Wal archive and Barman setup
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Vivek Gadge
Date:
Subject: Guidance on Calculating max_locks_per_transaction for a Highly Partitioned Environment
Next
From: Ron Johnson
Date:
Subject: Re: Guidance on Calculating max_locks_per_transaction for a Highly Partitioned Environment