| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Pgbackrest info output interpretation |
| Date: | 2025-11-14 13:42:46 |
| Message-ID: | CANzqJaDdUY-5ghtUHzurDxp6yF06nhAkiF+cj=C+UaZPdFtSNw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Nov 14, 2025 at 3:27 AM KK CHN <kkchn(dot)in(at)gmail(dot)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(at)db1 as16]# du -h -d 1
> 5.3G ./data
> 25G ./tablespace
> 30G .
> [root(at)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2025-11-14 13:48:57 | Re: Pgbackrest info output interpretation |
| Previous Message | KK CHN | 2025-11-14 08:32:38 | Pgbackrest info output interpretation |