Re: Barman WAL size issue

From: Marco Nietz <pg(at)mnietz(dot)de>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Barman WAL size issue
Date: 2017-11-30 06:54:40
Message-ID: 4823dcac-7607-4dcd-37e2-568799eb74f9@mnietz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Information to unsubscribe can be found here:

https://wiki.postgresql.org/wiki/PGLister_Announce

Am 29.11.2017 um 23:35 schrieb Sean G:
> why are we getting these emails?
> how can we unsubscribe from this list?
>
> suddenly these emails started to come into my email account and I could
> not find a way to unsubscribe??????
>
> this is against the law to get emails without any link to unsubscribe
> from the emails.
>
>
>
>
>
> On Wednesday, November 29, 2017, 5:59:02 AM EST, Günce Kaya
> <guncekaya14(at)gmail(dot)com> wrote:
>
>
> 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 <guncekaya14(at)gmail(dot)com
> <mailto:guncekaya14(at)gmail(dot)com>> 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 <pg(at)mnietz(dot)de
> <mailto:pg(at)mnietz(dot)de>> 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(at)gmail(dot)com <mailto:shreeyansh2014(at)gmail(dot)com>
> <mailto:shreeyansh2014(at)gmail(dot)c om
> <mailto:shreeyansh2014(at)gmail(dot)com>>> wrote:
>
>
>
>     On Tue, Nov 28, 2017 at 2:47 PM, Günce Kaya
> <guncekaya14(at)gmail(dot)com <mailto:guncekaya14(at)gmail(dot)com>
>     <mailto:guncekaya14(at)gmail(dot)com
> <mailto:guncekaya14(at)gmail(dot)com>> > 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 <https://tr.linkedin.com/in/gu ncekaya
> <https://tr.linkedin.com/in/guncekaya>> - Twitter
>         <https://twitter.com/gguncesi>  - Blog
>         <http://www.guncekaya.blogspot .com.tr/
> <http://www.guncekaya.blogspot.com.tr/>>
>
>
>
>
>     -- http://www.shreeyansh.com <http://www.shreeyansh.com>
>
>
>
>
> --
> Gunce Kaya
>
> Linkedin <https://tr.linkedin.com/in/gu ncekaya
> <https://tr.linkedin.com/in/guncekaya>> - Twitter
> <https://twitter.com/gguncesi>  - Blog
> <http://www.guncekaya.blogspot .com.tr/
> <http://www.guncekaya.blogspot.com.tr/>>
>
>
>
>
>
> --
> Gunce Kaya
>
> Linkedin <https://tr.linkedin.com/in/guncekaya> - Twitter
> <https://twitter.com/gguncesi> - Blog
> <http://www.guncekaya.blogspot.com.tr/>
>
>
>
>
> --
> Gunce Kaya
>
> Linkedin <https://tr.linkedin.com/in/guncekaya> - Twitter
> <https://twitter.com/gguncesi> - Blog
> <http://www.guncekaya.blogspot.com.tr/>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Kliukin 2017-11-30 09:23:28 Re: 'replication checkpoint has wrong magic' on the newly cloned replicas
Previous Message Andres Freund 2017-11-30 00:41:07 Re: 'replication checkpoint has wrong magic' on the newly cloned replicas