DB size value different than "/data" dir size - Mailing list pgsql-admin

From Ghiurea, Isabella
Subject DB size value different than "/data" dir size
Date
Msg-id aa68b26ba58b43c980648d76c27f4ce9@nrc-cnrc.gc.ca
Whole thread Raw
Responses Re: DB size value different than "/data" dir size
Re: DB size value different than "/data" dir size
List pgsql-admin

Hi List,

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)


[ 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?

thank you !

Isabella

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Pg_logical
Next
From: Ron Johnson
Date:
Subject: Re: DB size value different than "/data" dir size