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

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