Request a Demo
Home   >   mailing lists

Re: Pgbackrest info output interpretation - Mailing list pgsql-general

From Ron Johnson
Subject Re: Pgbackrest info output interpretation
Date
Msg-id CANzqJaDdUY-5ghtUHzurDxp6yF06nhAkiF+cj=C+UaZPdFtSNw@mail.gmail.com
Whole thread Raw
In response to Pgbackrest info output interpretation  (KK CHN <kkchn.in@gmail.com>)
List pgsql-general
Tree view
On Fri, Nov 14, 2025 at 3:27 AM 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, 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!

pgsql-general by date:

Previous
From: KK CHN
Date:
Subject: Pgbackrest info output interpretation
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Pgbackrest info output interpretation