pg_upgrade --link

From: Brajendra Pratap Singh <singh(dot)bpratap766(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_upgrade --link
Date: 2026-09-15 01:38:35
Message-ID: CAFD-joPJa4t_VpsEx3Dpi4uKHmuDbKi-eKOwW4A2BO5zmVN=2g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Team,

I have performed the production database upgrade from postgresql 13 to 17
version using pg_upgrade --link method on ubuntu 22.04 successfully.

Now after few days of upgrade, while dropped one database of size 900+ GB
successfully, the space not get reclaimed physically from mount point
/usr/pgdata.

Old PG13 data directory: /usr/pgdata/data1 --> size 4.5TB

New PG17 data directory:
/usr/pgdata/data17 --> 5.6GB

I didn't perform the delete_old_cluster.sh yet.

I can see that the oid of this dropped database is present in PG13 data
directory base location and occupying 972GB size, while it's not present in
PG17 data directory base location.

Now my doubt is if I removed Old data directory, will it cause any impact
on running PG17 cluster.

Please suggest the best and safe approach to reclaim the space.

Thank you so much..

Regards,
BPratap

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2026-09-15 02:33:19 Re: Upgrading 6 versions between 2 systems
Previous Message Adrian Klaver 2026-09-14 22:23:07 Re: Upgrading 6 versions between 2 systems