MIME-Version: 1.0
References: <CAKgGyB-4HmSMCg8L1_HCvK6jF=-bJtxn9v4oCH-jY0EdzKH-Lw@mail.gmail.com>
In-Reply-To: <CAKgGyB-4HmSMCg8L1_HCvK6jF=-bJtxn9v4oCH-jY0EdzKH-Lw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 14 Nov 2025 08:42:46 -0500
Message-ID: <CANzqJaDdUY-5ghtUHzurDxp6yF06nhAkiF+cj=C+UaZPdFtSNw@mail.gmail.com>
Subject: Re: Pgbackrest info output interpretation
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e4722706438e2ccd"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDdUY-5ghtUHzurDxp6yF06nhAkiF%2Bcj%3DC%2BUaZPdFtSNw%40mail.gmail.com>
Precedence: bulk

--000000000000e4722706438e2ccd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Nov 14, 2025 at 3:27=E2=80=AFAM KK CHN <kkchn.in@gmail.com> wrote:

> Hi,
>
> I am having confusion trying to understand the database size, backupsize
> and repo backup size..
>
> In my DB server I have du output as follows.
>
> /data/edb/as16
> [root@db1 as16]# du -h -d 1
> 5.3G    ./data
> 25G     ./tablespace
> 30G     .
> [root@db1 as16]#
>
> On my Repo Server pgbackest info says ....
>
> full backup: 20251114-121504F
>             timestamp start/stop: 2025-11-14 12:15:04+05:30 / 2025-11-14
> 12:20:58+05:30
>             wal start/stop: 000000010000000500000024 /
> 000000010000000500000024
>             database size: 3GB, database backup size: 3GB
>             repo1: backup size: 431.0MB
>
> Could someone shed some light on    431 MB and database size:3GB, databas=
e
> backup size : 3GB  compared to the DB cluster on disk usage output ?
>
> How to correlate the pgbackrest ( info) database size, database backup
> size and repo1 backup size     and actual du output on DB cluster.
>

Do you have the job log at "detail" level?  That lists every file which is
backed up.  Sadly, no compression rates.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000e4722706438e2ccd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Nov 14, 2025 at 3:27=E2=80=AFAM K=
K CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com">kkchn.in@gmail.com</a>&gt; =
wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi,=C2=A0 =C2=A0 =C2=
=A0<div><br></div><div>I am having confusion trying to understand=C2=A0the =
database size, backupsize and repo backup size..</div><div><br></div><div>I=
n my DB server I have du output as follows.</div><div><br>/data/edb/as16<br=
>[root@db1 as16]# du -h -d 1<br>5.3G =C2=A0 =C2=A0./data<br>25G =C2=A0 =C2=
=A0 ./tablespace<br>30G =C2=A0 =C2=A0 .<br>[root@db1 as16]#<br><br></div><d=
iv>On my Repo Server pgbackest info says ....=C2=A0</div><div><br></div><di=
v>full backup: 20251114-121504F<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 timestamp start/stop: 2025-11-14 12:15:04+05:30 / 2025-11-14 12:20:58+0=
5:30<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 wal start/stop: 000000010=
000000500000024 / 000000010000000500000024<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 database size: 3GB, database backup size: 3GB<br>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 repo1: backup size: 431.0MB<br><br>Could so=
meone shed some light on=C2=A0 =C2=A0 431 MB and database size:3GB, databas=
e backup size : 3GB=C2=A0 compared to the DB cluster on disk usage output ?=
<br><br>How to correlate the pgbackrest ( info) database size, database bac=
kup size and repo1 backup size =C2=A0 =C2=A0 and actual du output on DB clu=
ster.=C2=A0</div></div></blockquote><div>=C2=A0</div><div>Do you have the j=
ob log at &quot;detail&quot; level?=C2=A0 That lists every file which is ba=
cked up.=C2=A0 Sadly, no compression rates.</div></div><div><br></div><span=
 class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"g=
mail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauc=
e.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt=
; lobster!</div></div></div></div></div></div>

--000000000000e4722706438e2ccd--