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