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

On Fri, Aug 8, 2025 at 7:17 PM Ghiurea, Isabella <
Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca> wrote:

> Hi List,
>
> I am running PGSQL version 12.3
>

Ignoring the fact that PG 12 is nine months EOL, 12.3 is missing a _lot_ of
bug fixes. You should be on 12.22.

> 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)
>
>
> [ Mention in standby PG db the size matches the /data sum file size and
> also matches with the size reported in Pg active for pg_size_pretty() or
> pg_database_size ]
>
>
> What can be the issue?
>

What's in $PGDATA?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!