Re: Barman WAL size issue - Mailing list pgsql-admin

Hi Marco, Backup process complete successfully. Now, WAL Size: 3.3 GiB. Everything seems fine. Thank you again for your helps. Regards, Gunce On Wed, Nov 29, 2017 at 10:29 AM, Günce Kaya wrote: > Hi Marco, > > Sorry for delay. I just want to see what's gonna happen in next backup > process. We use archiving via archive_command that includes rsync. I > checked log file and I did not faced any error about archive_command or > rsync process. Current backup still continuous. Backup process takes long > time and I'm gonna look at barman list-backup command and I'll share if > still continued this problem. > > Thank you for your helps. > > Regards, > Gunce > > On Tue, Nov 28, 2017 at 2:43 PM, Marco Nietz wrote: > >> Hi, >> >> which wal method are you using? Wal Streaming or archiving by using >> archive_command? >> >> In case of streaming, you could check if receive-wal process is running >> on the backup host and connected to the barman replication slot on the >> postgresql server. >> >> In the other case, check your postgresql logfile if you have errors about >> the archiving. >> >> >> Greetings, >> Marco >> >> >> >> Am 28.11.2017 um 11:51 schrieb Günce Kaya: >> >>> Hello, >>> >>> There are some cron which execute insert, update statement daily. It's >>> not possible nothing happened after previous backup. So, do you have >>> another idea about that? >>> >>> Regards, >>> Gunce >>> >>> On Tue, Nov 28, 2017 at 12:44 PM, Shreeyansh Dba < >>> shreeyansh2014@gmail.com > wrote: >>> >>> >>> >>> On Tue, Nov 28, 2017 at 2:47 PM, Günce Kaya >> > wrote: >>> >>> Hi all, >>> >>> We use Barman for backup. I checked latest backup as to whether >>> having latest backup is success and I saw WAL size is 0 B. >>> >>> -bash-4.1$ barman list-backup dbalpha >>> dbalpha 20171127T190002 - Tue Nov 28 09:43:40 2017 - Size: 326.0 >>> GiB - WAL Size: 0 B .... >>> >>> I think it's not normal. Any help would be appreciated. >>> >>> >>> ​This is quite normal scenario, I suspect as not many transactions >>> have happened since its previous backup was taken which resulted in >>> WAL size to 0 B​ >>> >>> >>> Regards, >>> Gunce Kaya >>> >>> Linkedin - Twitter >>> - Blog >>> >>> >>> >>> >>> >>> -- http://www.shreeyansh.com >>> >>> >>> >>> >>> -- >>> Gunce Kaya >>> >>> Linkedin - Twitter < >>> https://twitter.com/gguncesi> - Blog >> .com.tr/> >>> >> >> > > > -- > Gunce Kaya > > Linkedin - Twitter > - Blog > > -- Gunce Kaya Linkedin - Twitter - Blog