Re: DB size value different than "/data" dir size
| От | Ron Johnson |
|---|---|
| Тема | Re: DB size value different than "/data" dir size |
| Дата | |
| Msg-id | CANzqJaDkYSSKgLbdP4i+4ASgz9LqdM74Ah0BBMz9xeN5PkDqZA@mail.gmail.com обсуждение исходный текст |
| Ответ на | DB size value different than "/data" dir size ("Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>) |
| Список | pgsql-admin |
On Fri, Aug 8, 2025 at 7:17 PM Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.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!
В списке pgsql-admin по дате отправления: