Re: pg_upgrade: can I use same binary for old & new?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pf(at)pfortin(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_upgrade: can I use same binary for old & new?
Date: 2025-07-05 18:30:20
Message-ID: 65041.1751740220@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

pf(at)pfortin(dot)com writes:
> On Sat, 5 Jul 2025 11:11:32 -0700 Adrian Klaver wrote:
>> How did you measure above?

> # du -sb /var/lib/pgsql/data
> 8227910662297 /var/lib/pgsql/data

It's likely that there's a deal of bloat in that. Even if there's not
much bloat, this number will include indexes and WAL data that don't
appear in pg_dump output.

>> What was the pg_dump command?

> Didn't try given:
> $ df /mnt/db
> Filesystem Size Used Avail Use% Mounted on
> /dev/sdh1 17T 13T 3.0T 82% /mnt/db

I'd say give it a try; be sure to use one of the pg_dump modes
that compress the data.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-07-05 19:10:35 Re: pg_upgrade: can I use same binary for old & new?
Previous Message pf 2025-07-05 18:24:16 Re: pg_upgrade: can I use same binary for old & new?