public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: KK CHN <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: PgBackRest full backup first time : Verification
Date: Fri, 30 Aug 2024 08:45:56 -0400
Message-ID: <CAKAnmmJ7ESPd7N_3ve7GsBuRXUBvWhOSg2Kt3OifSG07QkDsLA@mail.gmail.com> (raw)
In-Reply-To: <CAKgGyB8JbhNJr4Y13CS-zu5Nk=4eZy6HeNwW0y0rW4j9XGpL4Q@mail.gmail.com>
References: <CAKgGyB8JbhNJr4Y13CS-zu5Nk=4eZy6HeNwW0y0rW4j9XGpL4Q@mail.gmail.com>
>
> database size: 146.9GB, database backup size: 146.9GB
> repo1: backup size: 20.6GB
It looks to me as though everything is working as expected. You took a full
backup of your system, which was around 147GB - most of which is in a
tablespace. It got compressed down to 20GB. You then took two incremental
backups, which are by definition much smaller and take a short amount of
time to run.
I can't restore back to the DB server right now to test it as it is a
> production server and down time granting is not immediately possible to
> test it ...
>
You do not have to restore to the same server or the same directory. You
can keep your production system running and do a test restore somewhere
else. Just make sure you specify --archive-mode=off (which prevents the WAL
from being shipped from the restored system to your existing production
repo)
[root@db1 data]# du -h
> returns 537 G
>
This is not relevant, as pgbackrest only cares about the Postgres data
directory (/data/edb/as16/data/)
149G /data/edb/as16/tablespace/ESS
This is where the rest of your backup size is coming from. Postgres and
pgbackrest consider this part of the data directory.
You really should spin up a test Postgres cluster and get very familiar
with how pgbackrest works, rather than continuing to flounder about on a
production system and rely on mailing lists to answer a bunch of questions
for you. While we can answer these questions, you will learn better from
experimenting and trying things out yourself on a non-prod system.
Cheers,
Greg
view thread (2+ messages)
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 full backup first time : Verification
In-Reply-To: <CAKAnmmJ7ESPd7N_3ve7GsBuRXUBvWhOSg2Kt3OifSG07QkDsLA@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