public inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: Priancka Chatz <pc9926@gmail.com>
To: Ertan Küçükoglu <ertan.kucukoglu@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Large backup size of pg_dump
Date: Wed, 20 May 2026 13:23:09 +0200
Message-ID: <CANnOdgbBJ_2Eizy48BkjbmjsHh2uUUxqX_pb6_zrpeMrtAAfJQ@mail.gmail.com> (raw)
In-Reply-To: <CAH2i4yfdgWf5N+ofPineFW2a97cFT0F9b255HmcEDJ06dc=huA@mail.gmail.com>
References: <CAH2i4yfdgWf5N+ofPineFW2a97cFT0F9b255HmcEDJ06dc=huA@mail.gmail.com>
When you store large objects, the actual data resides on pg_largeobject
table (https://www.postgresql.org/docs/current/catalog-pg-largeobject.html).
So your "app" table might not be the only thing to exclude in your dump.
Regards,
Priyanka Chatterjee
On Wed, May 20, 2026 at 9:18 AM Ertan Küçükoglu <ertan.kucukoglu@gmail.com>
wrote:
> Hello,
>
> I am using PostgreSQL 18.4 x64 on Windows Server 2022. There is a very
> small single database in the cluster.
>
> There are hourly pg_dump backups scheduled and database backup size is
> around 10GB.
>
> command line is like below
> pg_dump.exe -p 5432 -U dbuser --exclude-table=app -F p -b -c -f
> "hourly.bak"
>
> When I check the cluster directory size it is 4.1 GB.
>
> Database has one BLOB saved in a single record and it is 16MB in size and
> that is in the "app" table which is excluded from the backup file.
>
> I didn't understand about 2.5 times bigger backup sizes than the total
> cluster size. I do not know what to check either. Is there a way for me to
> make the hourly backup size smaller?
>
> Thanks & Regards,
> Ertan
>
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: pgsql-general@postgresql.org
Cc: pc9926@gmail.com, ertan.kucukoglu@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Large backup size of pg_dump
In-Reply-To: <CANnOdgbBJ_2Eizy48BkjbmjsHh2uUUxqX_pb6_zrpeMrtAAfJQ@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