[ovirt-users] oVirt Manager problem

[Christopher Pereira]

Hi Massimo,

Please check what is going on with your postgresql DB.

1) Log into the ovirt-engine VM
2) su - postgres
3) query table sizes with:

psql engine -c "SELECT nspname || '.' || relname AS relation,
     pg_size_pretty(pg_relation_size(C.oid)) AS size
   FROM pg_class C
   LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
   WHERE nspname NOT IN ('pg_catalog', 'information_schema')
   ORDER BY pg_relation_size(C.oid) DESC
   LIMIT 20;"

Probably it's the "audit_log" table.

On 24-02-2015 18:11, Massimo Mad wrote:
> I have a problem on my oVirt manager, the problem is that the 
> directory /var/lib/pgsql/data fills.
> Initially thinking that my file system /var/log 2Gb was too small now 
> have increased to 4Gb and is refilled, i have increased again to 5 Gb 
> and is refilled again.
> Why ?
> I have implemented the backup of the manager with the script 
> backup.sh, this could be the cause of the problem?
> Regards
> Massimo
>
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20150224/2a968c3c/attachment-0001.html>