Re: Barman WAL size issue

Поиск
Список
Период
Сортировка
От Günce Kaya
Тема Re: Barman WAL size issue
Дата
Msg-id CAAV2-mVs-eXc8Sz7MOzjSKXP1eMQknUvp7-5TVHwt4u2kon9xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Barman WAL size issue  (Marco Nietz <pg@mnietz.de>)
Ответы Re: Barman WAL size issue  (Günce Kaya <guncekaya14@gmail.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Marco Nietz
Дата:
Сообщение: Re: Barman WAL size issue
Следующее
От: Günce Kaya
Дата:
Сообщение: Re: Barman WAL size issue