Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKAx3-0006Q2-64 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Nov 2017 22:35:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKAx2-0007cF-Mn for pgsql-admin@arkaria.postgresql.org; Wed, 29 Nov 2017 22:35:32 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eKAx2-0007c6-1T for pgsql-admin@lists.postgresql.org; Wed, 29 Nov 2017 22:35:32 +0000 Received: from sonic307-10.consmr.mail.gq1.yahoo.com ([98.137.64.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eKAwy-0006va-Bd for pgsql-admin@lists.postgresql.org; Wed, 29 Nov 2017 22:35:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.ca; s=s2048; t=1511994925; bh=nmUYLZBJ7SY0VFzoMAvJtiX6QLTAlYnj7LokFAeST60=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=DlMZliv9On6jhnxexeU0NwVRHZTRDbaQjmm1mryTbUN+Ov5svyb0UTfgfr4kjUIPfX8wBY6kFQH03XTQw4SJih0r2Q7TFY8uLHZ35zaeVM4x4sxaeLBLYKXRs85/rWTIMYvTAfltgnI8VY41wLlEieuV9c2S8v8J7atdsvcwvM3B07ZpHS+J7nFv9r73VNojqfpHA/TuhLxScQg53pH2oNll+TfHW7NpUmq9KfWfRAPt731+OdnZJh83V/qm9PiPUv9oq5gg06nlSbZyDpQ5flDkNbBVJWMgdsWzrUYdusDwExMqv8bi3qtlIFn9SLArOqahEevDlGUmXowl5YW4/A== X-YMail-OSG: P6ZGPNIVM1nsWj91XGbquIyMyEyQxji39_oACYr6giWHLFbdG6Q96pW.i5jAO8a ySsOaIrqiupr4EQyo1sD_rlwR_vdoqRtKrUvCcMdiAx8nlFpWDc6b918PTh06V3e3h1VevZySmip G9Vy7AQUJNvVPwVea8pGjP5yEN9HTuWkzQPB3AAD87nucDcH.cQ.xxZdOWZsg0cmiAKnrgQf0qi3 fbkdND4Lyws8jvlTqUw_XzhXqFa_Y1JZs9e7ayXALMIqgwdKixPKER0snLFgmM0ZoR2.1kv7f4R0 x54V34RKXtPopn8mM1tbuUlq4cLf8BtmEfuyZerbZ2bZ9qN1ReLc9jbewK4GqY3pCmm80dg_wHTq OGZn6Vv.VBC9QDbIAbVWMFBAwrgA5DlMjPi7DXC.FdOW7oXBRxKVMKXlWeLAxH.OUW.xFVKJc0Ps H_AGy._zU.CMNyYjp7Qjr_efVDc9W5_RyEV8uKTXvHzegYNl0VDB7NgoitavF48zukxOadYo0mi6 pHlpLiv0LG8hvzVCuntdFxQd.LrgPjRQ- Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.gq1.yahoo.com with HTTP; Wed, 29 Nov 2017 22:35:25 +0000 Date: Wed, 29 Nov 2017 22:35:23 +0000 (UTC) From: Sean G To: Marco Nietz , =?UTF-8?Q?G=C3=BCnce_Kaya?= Cc: pgsql-admin@lists.postgresql.org Message-ID: <709645236.4282327.1511994923979@mail.yahoo.com> In-Reply-To: References: <9700d9ff-08f8-6730-69de-13806459c8d0@mnietz.de> Subject: Re: Barman WAL size issue MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4282324_1002970435.1511994923973" X-Mailer: WebService/1.1.10982 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36 Content-Length: 13913 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_4282324_1002970435.1511994923973 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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=C3=BCnce Kaya wrote: =20 =20 Hi Marco, Backup process complete successfully. Now, WAL Size: 3.3 GiB. Everything se= ems fine.=C2=A0 Thank you again for your helps. Regards,Gunce On Wed, Nov 29, 2017 at 10:29 AM, G=C3=BCnce Kaya w= rote: Hi Marco, Sorry for delay. I just want to see what's gonna happen in next backup proc= ess. We use archiving via archive_command that includes rsync. I checked lo= g 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 g= onna look at barman list-backup command and I'll share if still continued t= his problem. Thank you for your helps.=C2=A0 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 postgre= sql server. In the other case, check your postgresql logfile if you have errors about t= he archiving. Greetings, Marco Am 28.11.2017 um 11:51 schrieb G=C3=BCnce 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 id= ea about that? Regards, Gunce On Tue, Nov 28, 2017 at 12:44 PM, Shreeyansh Dba > wrote: =C2=A0 =C2=A0 On Tue, Nov 28, 2017 at 2:47 PM, G=C3=BCnce Kaya > wrote: =C2=A0 =C2=A0 =C2=A0 =C2=A0 Hi all, =C2=A0 =C2=A0 =C2=A0 =C2=A0 We use Barman for backup. I checked latest back= up as to whether =C2=A0 =C2=A0 =C2=A0 =C2=A0 having latest backup is success and I saw WAL s= ize is 0 B. =C2=A0 =C2=A0 =C2=A0 =C2=A0 -bash-4.1$ barman list-backup dbalpha =C2=A0 =C2=A0 =C2=A0 =C2=A0 dbalpha 20171127T190002 - Tue Nov 28 09:43:40 2= 017 - Size: 326.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 GiB - WAL Size: 0 B .... =C2=A0 =C2=A0 =C2=A0 =C2=A0 I think it's not normal. Any help would be appr= eciated. =C2=A0 =C2=A0 =E2=80=8BThis is quite normal scenario, I suspect as not many= transactions =C2=A0 =C2=A0 have happened since its previous backup was taken which resul= ted in =C2=A0 =C2=A0 WAL size to 0 B=E2=80=8B =C2=A0 =C2=A0 =C2=A0 =C2=A0 Regards, =C2=A0 =C2=A0 =C2=A0 =C2=A0 Gunce Kaya =C2=A0 =C2=A0 =C2=A0 =C2=A0 Linkedin =C2=A0- Twitter =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0- Blog =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --=C2=A0 =C2=A0 =C2=A0http://www.shreeyansh.com --=20 Gunce Kaya Linkedin =C2=A0- Twitter =C2=A0- Blog --=20 Gunce Kaya Linkedin=C2=A0-=C2=A0Twitter=C2=A0-=C2=A0Blog --=20 Gunce Kaya Linkedin=C2=A0-=C2=A0Twitter=C2=A0-=C2=A0Blog =20 ------=_Part_4282324_1002970435.1511994923973 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
why are we getting these emails?
how can we unsu= bscribe from this list?

suddenly these emails star= ted to come into my email account and I could not find a way to unsubscribe= ??????

this is against the law to get emails witho= ut any link to unsubscribe from the emails.





=20
=20
On Wednesday, November 29, 2017, 5:59:02 AM EST, G= =C3=BCnce Kaya <guncekaya14@gmail.com> wrote:


Hi Marco,

Backup process complet= e successfully. Now, WAL Size: 3.3 GiB. Everything seems fine. 
<= div>
Thank you again for your helps.

Regards,
Gunce

On Wed, Nov 29, 201= 7 at 10:29 AM, G=C3=BCnce Kaya <guncek= aya14@gmail.com> wrote:
Hi Marco,

Sorry for delay. I just want to see what's gonna h= appen in next backup process. We use archiving via archive_command that inc= ludes 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 s= hare if still continued this problem.

Thank you for your helps. 

= Regards,
Gunce

On Tue, Nov 28, 2017 = at 2:43 PM, Marco Nietz <pg@mnietz.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 postgre= sql server.

In the other case, check your postgresql logfile if you have errors about t= he archiving.


Greetings,
Marco



Am 28.11.2017 um 11:51 schrieb G=C3=BCnce 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 id= ea about that?

Regards,
Gunce

 On Tue, Nov 28, 2017 at 12:44 PM, Shreeyansh Dba <shr= eeyansh2014@gmail.com <mailto:shreeyansh2014@gmai= l.c om>> wrote:



    On Tue, Nov 28, 2017 at 2:47 PM, G=C3=BCnce Kaya <guncekaya14@gmail.com
     <mailto:guncekaya14@gmail.com> >= wrote:

        Hi all,

        We use Barman for backup. I checked latest back= up as to whether
        having latest backup is success and I saw WAL s= ize is 0 B.

        -bash-4.1$ barman list-backup dbalpha
        dbalpha 20171127T190002 - Tue Nov 28 09:43:40 2= 017 - Size: 326.0
        GiB - WAL Size: 0 B ....

        I think it's not normal. Any help would be appr= eciated.


    =E2=80=8BThis is quite normal scenario, I suspect as not many= transactions
    have happened since its previous backup was taken which resul= ted in
    WAL size to 0 B=E2=80=8B


        Regards,
        Gunce Kaya

         Linkedin <https://tr= .linkedin.com/in/gu ncekaya> - Twitter
        <https://twitter.com/ggunces= i>  - Blog
        <http://www.gunceka= ya.blogspot .com.tr/>




    --     http://www.shreeyansh.com<= /a> <http://www.shreeyansh.com>




--
Gunce Kaya

Linkedin <https://tr.linkedin.com/in/gu ncekaya<= /a>> - Twitter <https://twitter.com/gguncesi= >  - Blog <http://www.guncekaya.blogspo= t .com.tr/>




--
Gunce Kaya
=




--
Gunce Kaya
<= div dir=3D"ltr">
------=_Part_4282324_1002970435.1511994923973--