<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Massimo,<br>
<br>
Please check what is going on with your postgresql DB.<br>
<br>
1) Log into the ovirt-engine VM<br>
2) su - postgres<br>
3) query table sizes with:<br>
<br>
psql engine -c "SELECT nspname || '.' || relname AS relation,<br>
pg_size_pretty(pg_relation_size(C.oid)) AS size<br>
FROM pg_class C<br>
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)<br>
WHERE nspname NOT IN ('pg_catalog', 'information_schema')<br>
ORDER BY pg_relation_size(C.oid) DESC<br>
LIMIT 20;"<br>
<br>
Probably it's the "audit_log" table.<br>
<br>
<div class="moz-signature">
<style>
.signature, .small-signature {
font-family:"Calibri","sans-serif";mso-fareast-font-family:"Times New Roman";
color:#7F7F7F;
}
.signature {
font-size:10pt;
}
.small-signature {
font-size:8pt;
}</style>On 24-02-2015 18:11, Massimo Mad wrote:<br>
</div>
</div>
<blockquote
cite="mid:CADXHJqJzgQ04xnQafvi3GwqdRTk4iwLo1Hb8ScdovRQ8djV6CA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>I have a problem on my oVirt manager, the problem is that
the directory /var/lib/pgsql/data fills.<br>
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.<br>
Why ?<br>
<span id="result_box" class="" lang="en"><span class="">I
have implemented the backup of the manager with the
script backup.sh, t</span></span><span id="result_box"
class="" lang="en"><span class="">his could be</span> <span
class="">the cause</span> <span class="">of the problem</span><span
class=""> ?<br>
</span></span></div>
<span id="result_box" class="" lang="en"><span class="">Regards<br>
</span></span></div>
<span id="result_box" class="" lang="en"><span class="">Massimo<br>
</span></span>
<div>
<div><span id="result_box" class="" lang="en"><span class=""></span></span></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a>
<a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>