public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: DB size value different than "/data" dir size
Date: Fri, 8 Aug 2025 19:30:44 -0400
Message-ID: <CANzqJaDkYSSKgLbdP4i+4ASgz9LqdM74Ah0BBMz9xeN5PkDqZA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Fri, Aug 8, 2025 at 7:17 PM Ghiurea, Isabella <
[email protected]> 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!
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: DB size value different than "/data" dir size
In-Reply-To: <CANzqJaDkYSSKgLbdP4i+4ASgz9LqdM74Ah0BBMz9xeN5PkDqZA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox