Re: DB size value different than "/data" dir size

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Ghiurea, Isabella" <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: DB size value different than "/data" dir size
Date: 2025-08-10 19:27:31
Message-ID: 9e1ebefd12e1fc955eee580caca5e9c37fd005ca.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2025-08-08 at 23:17 +0000, Ghiurea, Isabella wrote:
> I am running   PGSQL version 12.3   cfg   master-slave  with  streaming replication
> and I am facing a issue in the present active Pg db. 
> The database size reported from  the following : pg_size_pretty() or pg_database_size()
> or sum all of db  objects is  grater than the  sum size of  all directories/files
> reported  under /var/lib/pgsql/data1/tbl_space_name/PG_12,,,xxx/ .  ( db data tablespace)

Perhaps some part of the data is in a different tablespace, maybe pg_default.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ghiurea, Isabella 2025-08-11 14:13:36 Re: Re: DB size value different than "/data" dir size
Previous Message Ron Johnson 2025-08-08 23:30:44 Re: DB size value different than "/data" dir size