public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Pgbackrest info output interpretation
Date: Fri, 14 Nov 2025 08:42:46 -0500
Message-ID: <CANzqJaDdUY-5ghtUHzurDxp6yF06nhAkiF+cj=C+UaZPdFtSNw@mail.gmail.com> (raw)
In-Reply-To: <CAKgGyB-4HmSMCg8L1_HCvK6jF=-bJtxn9v4oCH-jY0EdzKH-Lw@mail.gmail.com>
References: <CAKgGyB-4HmSMCg8L1_HCvK6jF=-bJtxn9v4oCH-jY0EdzKH-Lw@mail.gmail.com>
On Fri, Nov 14, 2025 at 3:27 AM KK CHN <[email protected]> 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, database
> 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.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Pgbackrest info output interpretation
In-Reply-To: <CANzqJaDdUY-5ghtUHzurDxp6yF06nhAkiF+cj=C+UaZPdFtSNw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox