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
This is a multi-part message in MIME format. --------------040302080100080607040003 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
--------------040302080100080607040003 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit <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> --------------040302080100080607040003--
participants (2)
-
Christopher Pereira -
Massimo Mad