Hi Gibran, How did you select the size of the fossology db? We use: SELECT SUM(relpages) AS val FROM pg_class INNER JOIN pg_stat_all_tables ON pg_stat_all_tables.relname = pg_class.relname WHERE schemaname='public'
My machine is running postgresql 8.3.9. I haven't verified this on a higher rev. Bob On Feb 26, 2010, at 11:11 PM, Furosh One wrote: > Perhaps someone knows why this might occur or if there's a quick check > or fo-something script I can run to refresh something. > I connected to the database and checked the size even though it's a > brand new install, I figured it had to have some size to it. > > Fossology size is over 1gb but displays 0. > > > It's seems to be over 1GB, wonder why it's not displayed. > > List of databases: > ====================== > Name | Owner | Encoding > -----------+----------+----------- > fossology | fossy | SQL_ASCII > postgres | postgres | UTF8 > template0 | postgres | UTF8 > template1 | postgres | UTF8 > (4 rows) > > pg_size_pretty > ---------------- > fossology db > ---------------- > 1266 MB > (1 row) > ====================== > > Dashboard shows: > ============= > Database Metrics > Metric Total > FOSSology database size 0 (0) > > -Regards, > Gibran > _______________________________________________ > fossology mailing list > fossology@fossology.org > http://fossology.org/mailman/listinfo/fossology _______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
